Hello all,
This is my first post on this site, but I have used this site on numerous occasions to get solutions to my problems. But as every good programmer knows, the more you build the more complex things in your DB gets. I would consider myself quite adept at VBA, but I have no idea how to solve my problem:
I have 4 (pertinent to the question) tables. These tables are: "ExistingClientTable", "ExistingClientContactTable", "ExistingClientAddressesTable", and "ProspectiveClientTable".
The "ExistingClient...." tables have a relationship under the field "File Number" in which the primary key (also named File Number) is located in the "ExistingClientTable".
The "ProspectiveClientTable" has a primary key of its own for good reason.
I would like to create a button that creates a new record where fields from ProspectiveClientTable = ExistingClientTable, which also generates a new File Number.
For the rest of the data in the ProspectiveClientTable, I would like to append those records, automatically fetching the last File Number created.
I've looked around for solutions to my problem, but cannot seem to find them anywhere. I would LOVE any help on this, as this is beginning to give me a headache to resolve. :banghead:
This is my first post on this site, but I have used this site on numerous occasions to get solutions to my problems. But as every good programmer knows, the more you build the more complex things in your DB gets. I would consider myself quite adept at VBA, but I have no idea how to solve my problem:
I have 4 (pertinent to the question) tables. These tables are: "ExistingClientTable", "ExistingClientContactTable", "ExistingClientAddressesTable", and "ProspectiveClientTable".
The "ExistingClient...." tables have a relationship under the field "File Number" in which the primary key (also named File Number) is located in the "ExistingClientTable".
The "ProspectiveClientTable" has a primary key of its own for good reason.
I would like to create a button that creates a new record where fields from ProspectiveClientTable = ExistingClientTable, which also generates a new File Number.
For the rest of the data in the ProspectiveClientTable, I would like to append those records, automatically fetching the last File Number created.
I've looked around for solutions to my problem, but cannot seem to find them anywhere. I would LOVE any help on this, as this is beginning to give me a headache to resolve. :banghead: