hello everyone,

anyone knows the solution for this problem:

table product witrh product_id, product_name and product_prize

table bill, with Billing_ID, Billing_date, product_ID

in the layout of bill (it's planned for making bills)

i wanna choose a product, for that i use a list. The problem is only the product_id can be chosen. But i only want the product name to be choosen. The costumer don't have to know the product_id but only the produduct_name.

how can i solve this?

thx in advance

bill.zip

Here's a revised file. I hope this is what you wanted.

I reversed the order of your relationship and allowed new records to be created. Also, made changes to your value list.

Hope this helps.

Al

bill_rev_332006.zip

hello thx for your time and help.

But im wondering what extra options i have right now. The output looks the same.

I see 2 differences

1- The value list looks better this way

2- The relationship, u have marked the option: insert record through relationsship.

But im wondering if the second change was really needed, didn't my first version of bill do the same thing? I could make new record without marking that option. asnd the relationship was made because of the valuelist input.

What am i missing?