Monday, February 13, 2012 11:44 PMi have 3 tables each related in 1 to many relation and i have 23 tables each realted in 1 to 1 relation to each of the first 3 tables. how can i do a form for these 23 tables?
Tuesday, February 14, 2012 2:42 AMAnswererWhat do you mean by "do a form for these 23 tables"? Every table (those 23) should have a key referenced to the those three tables
Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Tuesday, February 14, 2012 5:51 AM
In 23 tables you need foreign key for each of the three table. (PK and FK) and as you mentioned your relation is 1 to 1. I guess if you use a unique and no null constiants or each reference key on the 23 tables.
If you want to create from in VB or C# you can use views to query your data or SP to query and DML your data.
I hope this is helpful.
Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid
- Marked As Answer by Ed Price - MSFTMicrosoft Employee, Owner Thursday, December 06, 2012 1:51 AM