Adding data from linked table and regular table to a form

M

Mishanya

I have a linked table (with Excel) wich is updated from time to time by
adding/deleting a new record of 4 fields.
I have a regular table with 4 more fields (wich are lists of values), wich
have to be appended in a form to the fields from the linked table and be
chosen manually.
I can not relate the tables, cus the linked table can not have a key.
I don't want to update the regular table by adding a new record whenever it
has to be done, but to do it in the form - I mean, every time a new record is
added to the linked table, a new record appears in the form and it has 4
already filled fields and another 4 waiting for chosing from the lists (wich,
in turn, update the regular table).
How can I do it (directly by a form or by building a query first)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Adding data to MS Access from csv file 0
Combining a data from a linked table and a regular table in one fo 5
Dynamic Naming of Form Button 3
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Creating a Chart on form from selected data in query. 0
Adding sequence numbers to paragraphs 0
Macro to copy table of contents to a new doc 0

Top