I have 3 tables, tbl_Records, tbl_Clients and tbl_Salesperson where tbl_Records is my main table. tbl_Clients and tbl_Salsperson are enforced to tbl_Records (1 Client,Salesperson to many Records)

I have built a form with 2 subforms displaying the client and salesperson data for each Record. The Subforms are purely for display purpose and are read only. The data comes from two other pop up forms. The pop ups return record IDs to the main form and store them in the Foreign Key fields. The idea is that the subforms then get requeried to display the correct record.

My problem is that I cannot requery either subform until both subforms have been populated with data. Error 3201, "Related record required in ... ". Is there anway I can requery the individual subforms wihtout having to populate them both first?

I am wondering if there is a property that you can change in the relationships between the tables that will show all records, but only salesperson or client data where the two are equal?

I could be wrong though...

Mike

Mike
EchoVue.com

Thanks Mike

You are correct, I can remove referential integrity form the relations and then the forms do requery. However, I then lose the ability to cascade delete when say a client is deleted from the database. I suppose I could build queries to remove related records but I was hoping to keep enforced relations and minimize the number of database components / Work!

Found a solution!

By simply putting text controls onto the main form and binding them to the FK's will force a refresh of its related subForm!

Please consider this topic closed.