binding data from different tables

[fullymooned]

I have a form with four fields
is it possible to bind each field to a different table. Presently I can bind all the fields in the form to only one table

Thank you

 

[Joe4]

Create a query that lists the fields you want from the 4 different tables. Then use this query as the source for your form.