Adding a field

[Taecca]

I have several tables linked to other databases, which I am not allowed to modify.

I need to create a form where my users will be able to add comments to each itemID. (itemID and other details are part of the linked tables.

I have created my own table with 2 columns: ItemID and Comments.

Now I need to create a form where my users will be able to pick an itemID and insert a comment.

Can it be done? how?

 

[PHV]

Have you tried to follow the combo wizard ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Taecca]

I am not sure I understand what you mean?

When I try to create a form I have to pick a table. If I pick my table, as of now columns ItemID and Comments are empty.

How do I make a form that allows the user to select an itemID, or ItemName and description from the linked tables and insert a comment in my table?