Link to home
Start Free TrialLog in
Avatar of Jass Saini
Jass Saini

asked on

Main form and Sub forms

Hello,

Could I do a Main form of my query that is based off one of my table and my table is the sub form..is this possible?
Avatar of PatHartman
PatHartman
Flag of United States of America image

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.
I with Pat.

This is confusing...

Can you explain what you need here?

ex:
I have a query that displays _______________
I want to have a subform that displays ___________________
I need this because _______________________________
Avatar of Jass Saini
Jass Saini

ASKER

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.
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...
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks this will work because I already have a tbl with all the analyst names