Form Troubleshooting

[That Secretary]

I have created a database which tracks all information concerning our
seminars: attendees, companies, book orders, paid/unpaid, etc. I recently
re-organized the database, separating attendees, companies, and seminars into
separate tables. Since many companies send more than one attendee to
different seminars, I created a drop-down combo box for CompanyName entry in
the AttendeesForm. However, when it catalogs it in the AttendeesTable,
companies are listed by their ID number. I cannot find the problem, and I
believe this is preventing me from pulling up the data in reports and
queries. Can anyone help?

 

[Carl Rapson]

Actually, that's just what you want. You want to store the ID number of each
company, not its name. What if the name changes?

In your reports and queries, join to the master table of companies (through
the ID) to get the company name.

Carl Rapson

 

[That Secretary]

Ok, I joined the Company field in the AttendeesTable to the ID in the
CompaniesTable, and I received an error message that there was a type
mismatch. What do I do?

 

[Carl Rapson]

What are the data types of the ID fields in the two tables? They should be
the same. If the company ID is being stored in the AttendeesTable, the field
data type should be the same as the type of the ID field in the
CompaniesTable.

Carl Rapson

 

[That Secretary]

Thank you!!! (I can't believe I missed that)

What are the data types of the ID fields in the two tables? They should be
the same. If the company ID is being stored in the AttendeesTable, the field
data type should be the same as the type of the ID field in the
CompaniesTable.

Carl Rapson