I need some help...
I have a database that I am using Crystal Reports 2008 to connect to.
I have a table called "PRICE" set up with the following fields: [TYPE], [SERVICE], [FEE]
The table data looks like this:
The correlation between the 2 tables does not make sense to me!
If the Serivce_ID = Type, there is nothing to tell me which type you want.
For example if Service_ID = 1, looking at the Price table, there are 3 Rows that are of type 1 with fees of 100, 250 & 350. Which one?
If the Service_ID = Service, you have the same problem as above! Too many duplicates of any one Service to make a determination of which Fee is correct.
Your REPORT table needs a Type_ID as well as a Service_ID to make any kind of meaningful join.
This also should be posted in one of the forums specific to your database rather than New Members!