With a database of product information, I need to build several ads a month. I was thinking that a possible method could be having one form for all the products, and then making forms for each ad. That way the same product could exist in any number of ads. The ad forms would just need two fields: page number and page position + the product (identified by the unique SKU or key field). Problem is I can't figure out how to link in the product records. Can this be done with the 'lookup' field?

Any help would be appreciated.