auto fill

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

Guest

I have a table set up with contact info (Company name, phone, address...). I
know want to keep more specific sales data in the main database. I will have
multiple sales from each company and do not wish to have to reenter the basic
contact info. I would like to just choose the Company name from a scroll list
and then have the program auto fill in the other (address, phone, ...) in the
main dbase.

Or do I really need to do that?? Bottomline is that I need one report that
shows the contact info along with the specific sales data and don't want to
have to renter the basic contact info for every sale.
 
Realistically, all you need to record associated with each sale is the Id of
the company in question. You don't need the other information, other than to
confirm that you've picked the correct Id. You definitely don't want to
store the data redundantly.
 
OK, then what type of box/field do I place in my sales form to be able to
pull in the ID of the account for that particular sale. Thanks
 
Assuming you've got a reasonable number of accounts (say only a few
hundred), use a combobox. Have the Id as, say, the first column in the
combobox, bind that column to the field in your table, and hide the first
column of the combobox.

If you've got a large number of accounts, take a look at what Allen Browne
has at http://www.allenbrowne.com/ser-32.html
 
OK, something went wrong I pulled in these two tables to do a report and I am
getting duplicate entries for each sales entry. Though I can pull all the
info that I need

Thanks for your patience!
 
Back
Top