Hi,

I have an issue with some relationship, not sure how to create the below:

Consider 2 tables: 1) services and 2) appointment.

In the table SERVICES, I have ServiceName and RRP (recommended price).

In the table APPOINTMENTS, for each record I want to be able to make 3 services. I have therefore the following fields:

Service1 (drop down list) / Price1 (manually entered) / RRP1

Service2 (drop down list) / Price2 (manually entered) / RRP2

Service3 (drop down list) / Price3 (manually entered) / RRP3

My issue is how to link ServiceName (from table Services) to the 3 Services (in the table Appointments) to have the corresponding RRP displayed next to each Service.

Thanks a lot for your help!

You need another table for the appointment items. Have a look at the example here:

http://fmforums.com/forum/showpost.php?post/309136/

Change Invoices to Appointments and Products to Services.

ok, thanks for the example, this is what I was looking for.. but I've been struggling with an issue for a few days..

I copied the idea of the sample, with the table LineItems, and the various variables I had to create. But in what is my Invoices Layout, I can't enter any information in the lines of the portal that links to the values in LineItems.. I've looked at everything (or at least it seems to me) but I can't find out why...

Would you have an idea?

Thanks

Make sure the relationship allows creation of records on the line items side.

at least now I know where the options of the relationships are!

thanks for the help!