Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to create a new column in a Form to be linked to multiple tables

HI, I am still working on my database. I am trying to make a form to add data to the set of preexisting data ( in an query). The additional data includes items to be stored to tables , not to the query that existing data is refer to.

If someone can show how to create new columns (items) in the subform grid and link them to the tables, I'd very much appreciate.

The form: PaymentEntryForm the query the main form is based on MainT

The new items are 'payment' and 'note' in the subform grid . The subform is based on an query, PriceAppendQ The relationship that I want to create with new items are: inputs to 'payment' ---> 'payment' in the table "ProcedurejuncT" inputs to 'note' ------> 'note' in the table "LogT"

The bottom lie is that when you create a new form, you choose one table/query to referred to. But I nee more than one table/query to store the information from the form.

As usual, I cannot appreciate enough for your help!

Yuriko C:\fakepath\inquiryfile.odb

How to create a new column in a Form to be linked to multiple tables

HI, I am still working on my database. I am trying to make a form to add data to the set of preexisting data ( in an query). The additional data includes items to be stored to tables , not to the query that existing data is refer to.

If someone can show how to create new columns (items) in the subform grid and link them to the tables, I'd very much appreciate.

The form: PaymentEntryForm the query the main form is based on MainT

The new items are 'payment' and 'note' in the subform grid . The subform is based on an query, PriceAppendQ The relationship that I want to create with new items are: inputs to 'payment' ---> 'payment' in the table "ProcedurejuncT" inputs to 'note' ------> 'note' in the table "LogT"

The bottom lie is that when you create a new form, you choose one table/query to referred to. But I nee more than one table/query to store the information from the form.

As usual, I cannot appreciate enough for your help!

Yuriko C:\fakepath\inquiryfile.odb

How to create a new column new fields/columns in a Form to be linked to multiple tables

HI, I am still working on my database. I am trying to make a form to add data to the set of preexisting data ( in an query). The additional data includes items to be stored to tables , not to the query that existing data is refer to.

If someone can show how to create new columns (items) in the subform grid and link them to the tables, I'd very much appreciate.

The form: PaymentEntryForm the query the main form is based on MainT

The new items are 'payment' and 'note' in the subform grid . The subform is based on an query, PriceAppendQ The relationship that I want to create with new items are: inputs to 'payment' ---> 'payment' in the table "ProcedurejuncT" inputs to 'note' ------> 'note' in the table "LogT"

The bottom lie is that when you create a new form, you choose one table/query to referred refer to. But I nee need more than one table/query to store the information from the form.

As usual, I cannot appreciate enough for your help!

Yuriko C:\fakepath\inquiryfile.odb