Suzanne Joy
Registered User.
- Local time
- Today, 14:56
- Joined
- Jan 23, 2004
- Messages
- 11
I have created a data entry form in which all the fields are bound to fields in one table. However, I have been informed that some of the fields in the table actually belong in a separate table, which I have now created. The properties of the fields in the second table are identical to those in the first table (to which the form's fields are bound). Without deleting any fields on the original form, may I change the source of these specific form fields to the appropriate fields in the second table? I will then delete the selected fields from the original table, and the form will appear unaltered. Related to this question is whether a form can contain fields from two or more tables.