Thedm Posted March 22, 2014 Share Posted March 22, 2014 Ok, Can anyone tell me if this is even possible? I have a fairly simple invoice solution... With one very troublesome issue. I have customer table, product and invoice table. I have an issue though that each product is base: Widgets, Gidgets, Gadgets, etc But on each and every widget I have a modification that I have to make: XL, engraved, Blue/Red, etc. along with notes for the invoice. But when I pull the records into the invoice in the portal and I allow modification in browse mode anything I type into one product automatically changes all like products. Ex: LINE #1: Widget: XL, Blue. Engraved. If I enter another Widget it automatically changes the previous entries on the invoice that share same product name/id. Is there anyway to not have it do this? Appreciate any insight, Thanks. Link to comment Share on other sites More sharing options...
LaRetta Posted March 22, 2014 Share Posted March 22, 2014 Hi! Welcome to FMForums!! :-) You are missing a critical table - LineItems. This is where you enter the items being purchased in a 1-to-many setup off of the Invoice. It inserts only the selected ProductID and then looks up the price from the Products table. Here is an example of a perfect configuration. http://fmforums.com/forum/topic/63425-auto-fill-one-field-with-text-from-two-fields/#entry300150 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3712 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now