Is it possible to add a table from a joined database onto a form and select items from the table to be filled into the form? For instance, if I want to let users see a list of stamps in the table, then have them click on the stamp name or number to add it to their collection and have it fill in the information on the form. I don't seem to see any information on this.

Thanks for the help.

Edited February 27, 200718 yr by Guest
removed shouting

Depending on whether or not you need to save the related table's data in the forms table, you might want to investigate auto-entry lookups, calculated values, or if you do not need to store the data for the form but only want to reference the info for display purposes, just put the related field on the form.