Can't figured it out

[nok]

Hi,

I have been trying to figured this out, but have no avail.

I have two tables, customers and services

What i like to do is to list all services name record in list view, and have a button on each record. when the user select that individual record and click on the button, have that record send to the customer's table "service" record field.

customer table - service, text field

services table - service_name text field

I would like to be able to sumit that record from table service (service_name) field to customers table (service) field name.

thank you,

sorry for my English

[bcooney]

You need three tables:

Customers

Services

CustServices ( a join table)

Customers can have many services related to them, correct?

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

[nok]

Thanks for replay.

basicly, it will be kiosk screen. Customer sign in with their name and phone number.

than it goes to service selection screen. They can choose, hair cut, color, perm, and ect. Then it goes to stylist select screen, lisa, rupita, ect. if can figured out the service part, than i would repeat the same process for the stylist screen.

Services have like hair cut, and in hair cut have short hair, long hair. Color have like long,short, ect... I am trying to do list view, because, i cant figured out how to display record on the button, it would be nice if i can somehow have record field like Joan shows on the button, and when they click the button, it summit that record to custom table field. i want to put it the customer table because, in waiting list, i want to pull all the record from customers.

hope this helps

thanks

[comment]

Seems very similar to:

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

and:

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