Hello all,
I´m having this issue:
I have one table, lets say, projects (tfgld800)
In the projects table I have proj, desc, fields.
Then I have another table, lets say amounts per project (tfgld801).

How can I make a maintenance table, where the first field, I can choose from table tfgld800.proj, and add the amounts related to that project?

In the table tfgld801, I should see
proj (choosed from tfgld800)
line (numerical user'sdata entry)
amount ( Numerical user'sdata entry)

Thank you in advance.

Hello,

Hope this will work for you!

Create a session from your tfgld801 table then in the form editor, link the project field to the (display) session of your tfgld800 table. Using the "zoom" and "zoom to" field in the Maintain form fields form. After linking, in the amount field after entering
amount, have a select clause filtering all that corresponds to what you select to the project field and then add the amount from the table(tfgld801) and the amount inputted.

Hello Belle,
Thank for your suggestion. I´ll try it.
Regards.