G
GL
Hi
I use a form on Continuous Forms view to edit records.
Each line of the form contains fields of two joined tables.
The first table is related to the second with a one-to- many relation.
Data for the records of each line are provided by a query.
What I would like to have is this:
When I type a value on the textbox of the primary key field of the first
table, if the value is entered for first time, then the values entered on the
rest of the textboxes are appended in new records of both tables.
If the typed value already exists in the first table, the data base auto
fills the rest fields of the first table and I have to fill the values for
the second table. That means a linked new records is opened in the second
table but not to the first one, otherwise I will have duplicate values.
Do you know if it is possible and how?
Thanks
GL
I use a form on Continuous Forms view to edit records.
Each line of the form contains fields of two joined tables.
The first table is related to the second with a one-to- many relation.
Data for the records of each line are provided by a query.
What I would like to have is this:
When I type a value on the textbox of the primary key field of the first
table, if the value is entered for first time, then the values entered on the
rest of the textboxes are appended in new records of both tables.
If the typed value already exists in the first table, the data base auto
fills the rest fields of the first table and I have to fill the values for
the second table. That means a linked new records is opened in the second
table but not to the first one, otherwise I will have duplicate values.
Do you know if it is possible and how?
Thanks
GL