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?
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?
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 __________________________ _____
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 __________________________
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.
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...
"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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks this will work because I already have a tbl with all the analyst names
ok
;-)
;-)