hawkins6423

Man thanks a lot for looking at it, I keep reading your explination trying to understand it haha. I forwarded your response to a friend of mine that is helping me with the database. Pretty much from what I can understand.... your saying that the way I have the vehicles drawing from a seperate table causes issues when drawing from the referenced feild. Man thats complicated. Thanks for the help let me know if you have any ideas.

the guest account should work..... if not try Ivan is user name and nothing (actually nothing as in dont type anything) as the password.

Matt, I already have what you did in that database. I appreciate your help a lot. I attatched my database.. the one im actually working on. If you go to the "DTA Sales Invoice" and put in a part # (i deleted all records to upload to forum) I would like the corresponding "Vehicle ID" from dta inventory to appear on the invoice via a lookup based on the FIRST part number in the portal. I think youll understand if you open it up and take a look at it. Thanks a lot. Actually the file is too big to upload on the forum so I put it on my server. www.discounttruckaccessories.com/dta.zip (thats the database zipped)

I already have a portal that displays the products and the relevant details. I am not familiar with using a value list, but thats probably what I need. So if i got what your saying correct, I can make a value list from the first feild in the portal (part number)? Also yes my part numbers are unique values. Thanks for the tips and help!

Hello all, I am making a solution in FMP10. It is an invoicing solution. I have a portal in my "Invoice" Table, that has a relationship with "Inventory" via a join table. The portal works great as far as when the employee types the part number in the invoice, the rest of the information is automatically added (price, short desc., etc). We are in the aftermarket automotive industry and are looking to make it so when the part number is entered (first part only (of the portal)) it will automatically insert the year make and model that part fits in a seperate feild. So pretty much in more of a layman's terms.... I have a portal and based off the first value entered (the first part number), I would like it to look up a value from a different table and insert it in a feild by the portal. Thanks!!!