I have the following tables:
tblProjects
I have the following forms:
fmProjects
When I add a project I need to have data from the tblQuotes and tblQuotesDetails to populate tblProjects and tblProjectsDetails respectively.
It is very easy to populate tblProjects from tblQuotes since it is a single record. Therefore I use:
Me.ClientProjects = Me.ClientQuotes
The question is: how to match the data of the 2 subforms? Since there will be more than one record per subform?
Any help is really appreciated.
tblProjects
ProjectsID (Primary key - exclusive)
ClientProjects
tblProjectsDetailsClientProjects
ProjectsDetailsID (Primary key)
ClientProjectsDetails (Secondary key)
tblQuotesClientProjectsDetails (Secondary key)
QuotesID (Primary key - exclusive)
ClientQuotes
Service
Rate
tblQuotesDetailsClientQuotes
Service
Rate
QuotesDetailsID (Primary key)
ClientQuotes (Secondary key)
Service
Rate
ClientQuotes (Secondary key)
Service
Rate
I have the following forms:
fmProjects
fmProjectsDetails (parent/child)
fmQuotefmQuotesDetails (parent/child)
When I add a project I need to have data from the tblQuotes and tblQuotesDetails to populate tblProjects and tblProjectsDetails respectively.
It is very easy to populate tblProjects from tblQuotes since it is a single record. Therefore I use:
Me.ClientProjects = Me.ClientQuotes

The question is: how to match the data of the 2 subforms? Since there will be more than one record per subform?
Any help is really appreciated.