Changing the table source to which a field is bound

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.
 
The short answer to your last question is "No". I think the best thing to do is split the table as you need to, create a query that includes all of the fields you will need from each table, and base your form on the query instead of on a table.

Your other option is to use subforms.
 
Thanks for getting back with me so soon. I appreciate the help.
 
Not a problem :)

Welcome to the forum, by the way.
 
When I created the original table, I was basing the table on a form I had been given. I put all the fields on the form into one table. Later, the End User informed me that half the fields should be linked to, and therefore populate, a separate table.
 
I'm not sure that it's a good idea to let the client dictate table structure
 

Users who are viewing this thread

Back
Top Bottom