Creating new table to use in another form

Smashed_Pumpkin

Hi all, hope someone can help with this.

I'd like to create a new field on the Purchase Return Order subform (6641) to do a lookup on a new table I have created (called Return Action Codes), and to return the value from the lookup onto the subform. Is this possible? If so, could someone please tell me how to do it? Many thanks!

marcidumi

Hi,

Add a new filed into underlying table from the subform. (Code)
and on the field properties set the Table relation to your new table !

Regards,
Marcel

DenSter

You have to have a lookup form for your new table and set the LookupFormID property of your new table to the ID of that form.

Then you add a new field to the Purchase Line table that links to your new table, and set the right table relation on the new field.

Then, all you need to do is add the new field to the subform and voila.

hth,
Daniel

Smashed_Pumpkin

You have to have a lookup form for your new table and set the LookupFormID property of your new table to the ID of that form

I've created a new form based on my new table, but how do I set the LookupFormID property on the table? I probably should have mentioned I'm relatively new to this sort of thing!

Thanks.

Edward_Bloomfield

Hi!

Open your table in the design tool, so you can see the fields in it.
Move down beyond the last field in the table to the first blank line.
Then go on the menu bar View -> Properties. In the list that appears is the properties of the table (As opposed to doing this on one of the fields, which gives you the field properties).

Amongst the list, you will see a property called LookupFormID.
Drill down in the field and pick the form you want.

Hope this is of help!

Smashed_Pumpkin

Hope this is of help!

Thank you, it worked perfectly

Thanks to everyone else for their help also!