One Field in a Table Auto Populate Another Field in Another Table
Posted: 2016-01-06 16:16
HI,
I tried searching for the answer to this solution , but since I don't know very much about this I might have missed the answer.
I have two tables Employees and Safety Tickets. In the Employees Table I have a field called Names.
In the safety tickets table I also have a field for names, what i was wondering is can I auto populate or have it pull the data from that field to create a new record in the safety tickets table.
Right now I use the parent/child lookup option to add new records to the safety ticket table for that field. But since the fields in both tables would be exactly the same . I thought it would be easier to have so when I add a new employee in the other table it would automatically show up in the safety tickets table and then I could just click on that name and edit the other fields in that table to what ever safety tickets they have.
Or maybe there is a better way to do it?
Thanks
I tried searching for the answer to this solution , but since I don't know very much about this I might have missed the answer.
I have two tables Employees and Safety Tickets. In the Employees Table I have a field called Names.
In the safety tickets table I also have a field for names, what i was wondering is can I auto populate or have it pull the data from that field to create a new record in the safety tickets table.
Right now I use the parent/child lookup option to add new records to the safety ticket table for that field. But since the fields in both tables would be exactly the same . I thought it would be easier to have so when I add a new employee in the other table it would automatically show up in the safety tickets table and then I could just click on that name and edit the other fields in that table to what ever safety tickets they have.
Or maybe there is a better way to do it?
Thanks