Don't know how to display data

[Vader]

I need help! I am working a medical billing database. I haveprices of tests according to the health plan, and need to display prices for plans Ato G, with tests 1 to 10. How can I combine tests and plans to show the priceof each one?


Example: Plan A Test 1 is $10 Plan B Test 4 is $15 and so on… price are already established.

[June7]

You need a table that associates plans with test prices.

I presume tests are associated with all plans but with different prices. Options:

1. a field for each plan in the prices table

2. normalized table like:

ID	Plan	Test	Price
1	A	1	10
2	A	4	12
3	B	1	13
4	B	4	15
5	C	1	15
6	C	4	17

[Vader]

Hi June7! Thanks for answering!

I have already a table where I put plan, test and price. Now, in the form I want to put Plan and Test in a Combo Box, so the user can select both of them, and automatically the price appears.

Two questions:
1. The table with Plan Test and Prices should be separated from the main table? (Name, address, age, etc.)?
2. If so, how can I connect them to the form?

Thanks for your help!

[June7]

1. Yes

2. Have a field in main table to save plan identifier (A, B, C)

You have a table to record tests associated with patients?

Review:

http://datapigtechnologies.com/flash...combobox3.html

http://datapigtechnologies.com/flash...combobox2.html