managing two value lists

[Robert Collins]

Hi

I'm trying to implement a new feature in my database which involves two tables.

the first is called 'salesline' and the second is called 'options'

Options has a mixture of records of various options that are either 'inclusive' or 'chargeable'

I am trying to get two value lists displayed in 'salesitems' table. one is for the inclusive options (i want to use radio buttons so users can only select one). the second is for 'chargeable optons' whereby users can select multiple optons by means of a checkbox set.

the problem i am having is getting the value lists to correctly display the correct records - i've done this sort of thing before and not had a problem, but i am doing something wrong or it would work!.

I've also got a field that totals up all the chargeable options costs.

i have included an example to show what i have done so far

any help would be greatly appreciated.

Robert

example Copy.zip

[Robert Collins]

Please , Anyone?

[comment]

Try it this way?

example Copy2.zip

[Robert Collins]

Try it this way?

Thanks very much - I see where I went wrong now with the relationship.