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
One Field in a Table Auto Populate Another Field in Another Table
Re: One Field in a Table Auto Populate Another Field in Another Table
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.

- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
- Need personalized consulting on your specific app and customizations? Book an online call with me here.
Re: One Field in a Table Auto Populate Another Field in Another Table
Yep that will work saves sometime , I can just do it when I create an Employee . Thanks