Main form and Sub forms


Could I do a Main form of my query that is based off one of my table and my table is the sub this possible?
Jass SainiAsked:
Who is Participating?
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
something like this:
You can but it doesn't make sense.  You are also likely to get conflict messages if you update data in one of the forms.  Sounds like your table design needs work.
Jeffrey CoachmanMIS LiasonCommented:
I with Pat.

This is confusing...

Can you explain what you need here?

I have a query that displays _______________
I want to have a subform that displays ___________________
I need this because _______________________________
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Jass SainiAuthor Commented:
So I am pulling a few fields from table1 and few from table2....parent/child linked by two common fields.

I can go through the records no problem and edit (input data ) into table2.

I don't want to go through all the records to find the hand full of records.  table1 is based on the names of the analyst and I want to pull only those records for that analyst based on the two common fields.
Jeffrey CoachmanMIS LiasonCommented:
You can do this , ...but I am still confused by your statement:
"parent/child linked by two common fields."

Typically a Part/Child is linked by *one* common field
tblCustomers.CustomerID--> tblOrders.CustomerID

So in your case you can make the main query the main form "Analysts"  (with a PK of perhaps AnalystID)
then create a subform form the "AlaylstRecords" table (whatever that means), ...again based on the foreign key of AnalystID...
Jass SainiAuthor Commented:
Thanks this will work because I already have a tbl with all the analyst names
Jeffrey CoachmanMIS LiasonCommented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.