Setting up dependancy relationships multiple levels

iโ€™m really after suggestions, on how i should go about doing this order form, im not after hugely detailed instructions, just suggestions or references on how a specific step could be done & or links to examples would be greatly appreciated.

I know my posts are a jumbled mess, it takes me like an hour to get out what i need to say and i know it doesnโ€™t make sense at times, apologies.

i have database of Staff members, Customers, Vehicles, Services & Line items

Staff Member {Drop-down) with the option to Add new
Customer {Drop-down) with the option to Add new
Vehicles {Drop-down) with the option to Add new (these vehicles are customer owned)
Services {Multiple option icon select for multiple services in single order}
Line items {dependant on service selected} but with manual price input for each

Once all the above details are created & or selected there are a few markup, tax & discount options mostly working in Percentages, options like

Markup {either drop-down or hidden static multiplier
Tax {drop-down} 10% default
Discount {drop-down} select anything between 0%-50%

at the end i have a โ€œRetail Priceโ€

I sort of got a lot of this working, the calculation side i was mostly calculating via google sheets and pulling data back into the app as โ€œresultsโ€

but its the dependencies, i could not get right, eg i pick Customer 1, but its showing a lost of all vehicles not a list of ONLY vehicles he owns. I would assume some sort of reference to them owning the vehicle?
its the "ownership side if things i keep messing up somewhere along the lines.

Cheers for your help. & its cool if i donโ€™t get any ill just keep reading and learning

Hypno

0 2 579
2 REPLIES 2

can i just pay someone do make this work.

From what youโ€™re saying here, it sounds like youโ€™ve got references between the customer table and the others; yes?

If so, then in the customers table, youโ€™ll find the Related columns that have appeared - one for each table you connected to the customer table with a reference.

Since youโ€™ve done this, you can use a de-reference formula to pull the related vehicles and such from the customer thatโ€™s selected.

On your order form, youโ€™ve got a field to select the vehicle; in the valid if, youโ€™d put something like this:

[Order_Customer].[Related Vehicles]

Hereโ€™s some further reading that might help:

Top Labels in this Space