I am building an application for tracking equipment on engineering projects. The db contains a table EqBasic which contains basic information about every equipment item in the project. There are also related tables that contain details about the equipment items. There are different related tables depending upon the type of equipment item.
I use a command button on the form for displaying/entering the basic info to add a new item, and that works well. Currently I have to manually create the record in the related detail table, but am trying to tie that process into the process of creating the new record in the basic table. So far I have no success at all. I can get the form for entering the details of the related item to open, and navigate to a new record, but nothing I have been able to do will allow me to programmatically put the necessary entry into the 2 fields used as a compound unique index to relate the 2 tables. The 2 fields for the unique index are 2 of the 3 fields that are concatenated for a complete equipment number. I have no issue entering them into the new record in the basic table, but can’t get them into the new record in the related table using VBA.
Any help will be greatly appreciated! I’ve been pulling out what little hair I have left for several days now on this problem.
Thanks,
Alan