Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 7436 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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

Posted

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.

Posted

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

Posted

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.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.