![]() ![]() I also created a form similar to the sample "My Wizard" form at the following link: I intend on using the ClientID to reference (don't know if that the right I guess I am doing something wrong but I am not able to populate the three tables from this form, with reference to the ClientID. Second - HRData, the third - ClientEmergenc圜ontact. For instance, I created 3 tabs and the first tab had to do with the client table, the Here are things that I tried: I created a form and added a "Tab Control" to the form and on each tab, I created fields for the different tables one each tab. Not want to create one long and never ending form to accomplish the task. ![]() ![]() Since I have the ClientID field Index set as "No Duplicate", and based on that ClientID field, I want to populate the rest of the tables or fields. Table and also made the "ClientID" field the "Foreign Key" in the "HRData" Table, for example. I made the ClientID field the "Primary Key" for the Client I am trying to create one (a single form) "Form" through which I can populate all three of the tables without have to fill out separate form for each table since they are all inter-related. I have a Database with a couple of tables in particular, I have 3 tables(Client, HRData & ClientEmergenc圜ontact) with are interconnect by means of "Relationships - primarily, one-to-many relationships ", and they are joined by ClientIDĪs a "Primary Key" in one table/tables and a "Foreign Key" in the other. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |