| | |
|
|
|
redundancy of repeat data info into fields |
|---|
| message from =?Utf-8?B?Q2Fyb2wgSG9yY2hsZXI=?= on 19 May 2004 |
I am working in the Public Defender Office and do the yearly expenditures of all vendors we use. If I am filling out a form and I am repeating a vendor but not necessarily the same amount how do I format it so that I don't have to keep typing the same info over and over. The fields I used was Vcode, vendor name, and vendor number. Can I work the vcode sothe once it is typed in it automatically gives the needed info into the vendor name and vendor number
|
| Jeff Boyce replied to =?Utf-8?B?Q2Fyb2wgSG9yY2hsZXI=?= on 19 May 2004 |
Carol
That will depend on whether you have a separate table of Vendors or are
entering all that information into your form/table for each expenditure.
A more relational design would be to have a table of Vendors, with
vendor-related information, and use a combobox on your form to "select" the
vendor for whom you are creating an expenditure record.
That way, you can use a query to link the Expenditure table rows to the
associated Vendor information, without having to re-enter it each time, AND
with having to store the same name/code/address/... information in multiple
rows. You'd only need to store the VendorID to be able to join back to the
Vendor information.
|
| =?Utf-8?B?WW9zaGk=?= replied to =?Utf-8?B?Q2Fyb2wgSG9yY2hsZXI=?= on 19 May 2004 |
You can make the look-up table to solve that problem.
You put your vender code, vender name and vender number in the vender table, right?
Then you use the look up wizard of data type in the any tables.
When you create the form with the look-up wizard, it is much easier to see the customer data.
I hope you got help this way.
If you have a question let me know, OK?
|
|
Archived message: redundancy of repeat data info into fields (Microsoft Access Error Message)
