Page 1 of 1

One Field in a Table Auto Populate Another Field in Another Table

Posted: 2016-01-06 16:16
by Surrey
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

Re: One Field in a Table Auto Populate Another Field in Another Table

Posted: 2016-01-06 19:59
by a.gneady
Hmm ... If the name field in the safety table is a lookup to the employees table, you could do this: In AppGini, select the employees table, then click the button 'Parent/children settings', and enable the 'safety' child records. to be displayed. After regenerating your app, you should see child safety records below any employee record you open. If you click the 'Add new' button in the safety records section, you can add a new safety record, where the employee name is automatically populated with the currently selected employee name.

Re: One Field in a Table Auto Populate Another Field in Another Table

Posted: 2016-01-06 20:33
by Surrey
Yep that will work saves sometime , I can just do it when I create an Employee . Thanks