By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,204 Members | 1,161 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,204 IT Pros & Developers. It's quick & easy.

How can i solve the problem?

P: 23
I am making a database for a diagnostic lab.

I am using tables with field like below
Name (value: Dacter x, Dacter y, Dacter z)

FIELD-Percentege of TestX
FIELD-Percentege of TestY
FIELD-Percentege of TestZ

FIELD-Percentege of TestX
FIELD-Percentege of TestY
FIELD-Percentege of Testz

FIELD-Percentege of TestX
FIELD-Percentege of TestY
FIELD-Percentege of Testz

TABLE4-Test info
FIELD-TestName (value: TestX, Testy, TestZ)


Here Every Doctor takes different percentage for Different Test (Example. TestX,TestY,TestZ) from the diagnostic lab.

I want When I select value for “NameOfDacter” and “TestName1” or “TestName2” “TestName3” in Memo Form, Percentege of that test should filled up from the respective DOCTOR table automatically Or by an update query.
How Can I do this? Plz help me…………..
Thanx In Advance.
Nov 19 '13 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 5K+
P: 5,397

Respectfully, your database is very poorly designed at this stage.
Please read:> Database Normalization and Table Structures.

Please work thru:
MS Access 2010 Tutorials
This link also has two links to theory on database design. I highly recommend working thru both of those links.
Nov 19 '13 #2

P: 8
I think I would concur with the last response if it is true you have separate table for each doctor. Fundamentally, I think what you are trying to do is this: Based on a test, provide a specific percent value to a doctor where for each test, the percent can change.
If the above business problem is stated correctly, then I would think you would need the following. First and obviously a table for the physicians where you have a unique doctor ID and data on the doctor that may be helpful in other business processes. Then you would need a table for the tests with testID, test name, etc. Then a look up table containing DrID, TestID, and Percent Value. Then when you select a test, it could then refer to other queries to provide the total assigned doctors with the numeric percent value for a particular test. This is high level of course and you would need to know more than basic Access to really do a good job. In essence though you need to build the ability to have a relations to a doctor to a test in a table that is many to many
Nov 19 '13 #3

Post your reply

Sign in to post your reply or Sign up for a free account.