I am trying to display data from several tables in a form (in-house part # and description from one table and manuf. and manuf.'s part # from another table) and allow the addition of a user-defined note for each record.
I've tried to create a table to allow storage of this note and I have created the connections on the Relationships page, but nothing gets filled into the columns of my new table.
Should I create a query to collect the data that is in the tables? But how would I have a field for the new note? I actually tried doing it this way, but a problem I ran into early was duplicate entries (the part number is the same, but some of the descriptions are a little different).
generally speaking if you have defined the realtionships when you come to design the form you need to include a list or combo box which pulls its data from the relevant parent table. sounds difficult.. not reallyu
open your form in design mode
select a combo or list box.. doesn't matter that much which you choose
follow the steps in the wizard.
so you probably want to look up the values in a table or query
you then specify that table or query
select what field(s) you want from that table or query
select store value in this field...... and specify what field you want to use
I have found a solution to the problem; I created a column in the source table (out on the network). This prevented the need to create another table and try and combine all the items together. Thanks for your help.