redundancy of repeat data info into fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
Back
Top