Can anyone steer me in the right direction here as to how I go about creating a form in access based on more than one table.
army88m2 0 Newbie Poster
Kegtapper 0 Junior Poster
if the db is relational try creating an SQL statement, then have the form linked to the new statement.
slurpee55 0 Light Poster
You need to have some matching item between the two tables - a unique ID is best, but you can use other things, as long as they are unique. Then make a query based on the two tables linked by the ID or whatever. In the query, have all the fields you need from the two tables - if that means everything, that is fine.
Then make the query the record source for your form.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.