I think I am having a senior moment. I have inventory records. Originally I had the purchase price as a number field. But I have decided I want to maintain a history of prices. I think there might be a benefit when negotiating prices with a vendor. I have added a related table of prices.
I have tied the two tables together with based on the primary key being the sequence number auto-assigned. How do I get the parent record to show the price added to the PriceTable (child table)?