New Record Forms

[LHolden]

When creating a new record using a Form, is it necessary to use the Foreign Keys which relate to Primary Keys in other tables, or is it possible to have the form understand that Subject A has an ID of 1 and automatically change the text to a number?

For example, if a table is designed so that it lists clients, and then is related to a brokers table by the BrokerID field, would it be possible to tell the form that you want Broker A added with the new record, and the form automatically interprets that as being BrokerID 1?

Thank you for any and all help!

 

[pbaldy]

Typically you'd use a combo box that included both fields. The ID could be hidden but be the bound column, so the user would see/select the text value but the ID value would be saved.

 

[LHolden]

I had the combo boxes set up, just didnt think of hiding the ID field for some reason. Thanks a bunch!

 

[pbaldy]

No problemo!