Brudders Posted September 8, 2004 Posted September 8, 2004 I am having a little problem with a DB that has three tables relationships are established and makes use of portals. The three tables are Customer, Cars, Invoices The theory is that 1st create customer which also updates cars table with required information. 2nd raise invoice that automatically populates customer name and car details. This works fine except if the customer has more than one car then the first record for cars is brough over into the invoice layout. . I need some kind of popuplist/mechanism that would enable the user to make a choice dependant on selection of cars. Any help offered is appreciated, I have attached example of what I am trying to acheive. Many Thanks Ray we1.zip
Fenton Posted September 8, 2004 Posted September 8, 2004 If you have more than 1 car per invoice, then you need a "join" file in between Invoices and Cars, with the Invoice ID and the Car ID. They are visible in a portal in Invoices. I've set up the basics. But you'll quickly see that you need a little script to create the portal records. With "allow creation of related records" on, it works, but you end up with extra stuff (labels, lines) in the "empty" row. But for a script you'll need a couple global fields, for passing the IDs. In 7 you can do this easily in one script. But we'll have to do that later. Also, personally I'd want a portal to choose the car, so you could show more data than a drop-down value list. we2.zip
Brudders Posted September 8, 2004 Author Posted September 8, 2004 Many thanks for the quick responce, I have looked at your modifications I can see where your going with it but tbh its not quite where I need to go. I am writing a garage autoshop repair app. I am pretty much finished as it is very basic but hey thats what the requirment is and tbh im glad as it's my first FM app. Requirment There will only ever be one car on invoice. But it is possible that customer could have more than one car. So I need a portal/mechanism on invoice that has a popup list listing customers cars so that the right car can then be selected, (this list should only show the customers cars not all). Once correct car is selected it would populate the full car details on invoice. There is also another portal on invoice which is pulling over the customers address details. Customer details are entered via customer layout but so is cars details via a portal. Any further assistance you could offer would be gratefully received.
Computer Geek Posted September 10, 2004 Posted September 10, 2004 Give this a shot and see if this is what you were looking for. 122707-we3.zip
Brudders Posted September 10, 2004 Author Posted September 10, 2004 Hi there thanks again, this is getting to be a habit :-) This is exactly what I am looking for with the exception of one thing and that is when you click on registration on invoice layout it should only list the registrations relating to the customer as defined in the customer layout. If you could shed some light on how to do that, that would be fantastic. Thanks again
Computer Geek Posted September 10, 2004 Posted September 10, 2004 Hello again. Simple fix. You just needed to specifiy in the value list the relation to pull the list from. See the attached. Good luck! 123040-122707-we3.zip
Brudders Posted September 10, 2004 Author Posted September 10, 2004 What a Star, Thanks. This is my first app using FM and have yet to learn all the tricks and capabilities so the feedback im getting in these forums is invaluble. Thanks for your help I really appreciate it.
Recommended Posts
This topic is 7436 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