I am trying to use data from one table when adding a new record to another table. What I want to know is if there is a way to add a drop down list on the add new record page so an item can be selected instead of having to type it. Any help would be appreciated!!!
Hi, On formatting (step 9) for the field you want, select 'lookup wizard' from the 'Edit As' box. Then click 'change' in the 'Edit Format' box. This lets you type in a static list, or select a table for the lookup. Hope that helps Pete