Table to form

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

Guest

I have a db which is basically a contact list in spreadsheet form. I created
a form to make it easier to work with in hard copy.
what my problem is is on the table there is multiple duplicate companies
listed only to show additional contact people. Example; xyz company has 2
available contact people so it shows up on the table 2 times. All the of the
information (co. name, address, ph. no. etc.) is the same. How can I have
only one company showing in my form but include all avalable contacts in the
single listing. NOTE; I dragged the "contact name" feild from the list box 3
times, but it shows the same name in each box.
 
Veronica said:
I have a db which is basically a contact list in spreadsheet form. I
created a form to make it easier to work with in hard copy.
what my problem is is on the table there is multiple duplicate
companies listed only to show additional contact people. Example;
xyz company has 2 available contact people so it shows up on the
table 2 times. All the of the information (co. name, address, ph.
no. etc.) is the same. How can I have only one company showing in my
form but include all avalable contacts in the single listing. NOTE;
I dragged the "contact name" feild from the list box 3 times, but it
shows the same name in each box.
Click to expand...

Open the table and go to tools/analyze/table. It will usually show you what
the problem is and offer to create the needed tables.

You can also do this by hand.
You need at least a Company table and a contacts table related to it.
 
Veronica,

Based on the fact that you have a one-to-many relationship between
Companies and Contacts, you need to have two tables to reflect this
realty, i.e. Company-related information in one table, and
Contact-related information (including the ID of the company each
contact is associated with) in another table.

As for the forms, the "standard" way to manage this is to make a form
based on the Companies table, and embed a continuous view subform on it,
based on the Contacts table.
 
Back
Top