I have a product table. One of the fields on the product table is site_id. Site_id determines which site owns the product. There is also a security table that determines the security of each client for each site. The security table has three fields: client,siteid,security. Each client can see every product, but you can only update products for sites that you have update security (security=3)

So as a client is spinning through the product table, I need a control to show the product.site_id. I could use a textbox while in BROWSE mode. But when the client is on a product where he has update security, and they are in ADD or EDIT mode, I want the site_id control to be a drop down of site_ids where they have update security (security=3)

Any design ideas?

Brenda