Reply to thread

Message: [QUOTE="Sprinks, post: 2556924"] Hi, smit. Assuming you have a table that contains this specialized information, you already have access to it via a query. It IS NOT advisable to try to store this supplemental information redundantly in your Rental table. It is already stored in one authoritative place that you have Access to. (pun intended) To *display* this information on your form, or in a report, etc., include these fields in a query, linking on the ProductID, and place controls bound to these fields on your form and/or report. Hope that helps. Sprinks [/QUOTE]