dpawar
asked on
What relationship and fields to create in Results Table
I have already created following tables
1. Sample Info (Fields: SampleID, Sample Name, TestCode)
2. Sample Results (Fields: ResultsID, SampleID, ???)
I dont know what fields I need to create here. Each SampleID can have multiple TestCode so accordingly that many number of record needs to be created in Sample Results table so Results can go there for respective tests. I am using SQL server 2005 back end and Access 2010 Front End.
Thanks.
DP
1. Sample Info (Fields: SampleID, Sample Name, TestCode)
2. Sample Results (Fields: ResultsID, SampleID, ???)
I dont know what fields I need to create here. Each SampleID can have multiple TestCode so accordingly that many number of record needs to be created in Sample Results table so Results can go there for respective tests. I am using SQL server 2005 back end and Access 2010 Front End.
Thanks.
DP
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Can you create different types of relationships in SQL server? Like one to one, one to many etc?
yes
ASKER
How to create different types of relationships in SQL server?
<How to create different types of relationships in SQL server?>
See this link:
http://www.eggheadcafe.com/community/aspnet/13/10047823/create-relationship.aspx
See this link:
http://www.eggheadcafe.com/community/aspnet/13/10047823/create-relationship.aspx
ASKER
Once I create the relationships, when I create a Sample ID, will the Result table automatically have SampleID because of reationship?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi! Good to have you back,
I have attached the relationship Diagram. How can I add SampleID in Result table? Should I have realtionship of TestCodeID with some other table? How can I create a record in Result Table when SampleID is created when Samples are logged in? I am using Access 2010 as front end and SQL server 2005 as back end.
I have attached sample Log In Form as well.
Thanks for your continued help.
DP
Relationship.jpg
LogIn.jpg
I have attached the relationship Diagram. How can I add SampleID in Result table? Should I have realtionship of TestCodeID with some other table? How can I create a record in Result Table when SampleID is created when Samples are logged in? I am using Access 2010 as front end and SQL server 2005 as back end.
I have attached sample Log In Form as well.
Thanks for your continued help.
DP
Relationship.jpg
LogIn.jpg
With all due respect, capricorn1 and I have already addressed your original question.
So in this case, it is fitting that you assign points here, close this question, and post your new issue as a new question.
Sound fair?
;-)
What you are asking now is an "Architectural" issue that has more to do with the interface layer than the design layer.
You can examine the "Orders" form in the Northwind sample Database for info on selecting a parent key when creating a Child record.
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c6661372-8dbe-422b-8676-c632d66c529c
;-)
JeffCoachman
So in this case, it is fitting that you assign points here, close this question, and post your new issue as a new question.
Sound fair?
;-)
What you are asking now is an "Architectural" issue that has more to do with the interface layer than the design layer.
You can examine the "Orders" form in the Northwind sample Database for info on selecting a parent key when creating a Child record.
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c6661372-8dbe-422b-8676-c632d66c529c
;-)
JeffCoachman
http://office.microsoft.com/en-us/access-help/demo-set-the-relationship-between-two-tables-HA010254901.aspx?pid=CH100739911033