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

Having trouble with seeing form in design view

P: 3
Hi this is my first post on the forums. I haven't really developed before with Access 2003 so trouble shooting with this application is not my forte. The issue at hand is, created a star schema with all the IDs in one table for the eight tables I created in design view, the datatype for all the IDs is number in this Table.
ID
EventID
ObsID
RecID
ActItemID
LocID
AssgnID
ImpctID
ProjID

The tables below are connected in a star schema to the ID table. The IDs field in these tables are autonumber, and the fields below are all text fields. I am also listing the relationship of the tables to the ID table above the tables below so you can see the relationship.The 1-1 and 1-many, relationship arrow starts from these very tables and ends in the ID table.

1->1
Events
EventID
Events

1->1
Observations
ObsID
Observations

1->Many
Recommendations
RecID
Recommendations

1->Many
Impacts
ImpctID
Impacts

1->Many
Action Items
ActItemID
Action Items

1->Many
Assignments
AssignID
Assignments

1->Many
Locations
LocID
Locations

1->Many
Projects
ProjID
Projects

I have linked each field in design view to a source from a table in the properties pallate in design view for forms. But still I can't see the fields in form view?? I would appreciate it if anyone could shed some light on where I am going wrong is it the design?? or the properties??

Thanks,

Hisham
Mar 4 '08 #1
Share this Question
Share on Google+
1 Reply


Expert Mod 2.5K+
P: 2,545
Well, it's novel - but it's not relational design. A star arrangement with all keys in one table is not going to give you relations that work when implemented as standard inner-joined tables, as all joined fields would have to be equal simultaneously to show any rows at all. No wonder there is a just a blank screen in form view!

I think you could benefit from reading the HowTo on relational table design and normalisation at http://www.thescripts.com/forum/thread585228.html

-Stewart
Mar 4 '08 #2

Post your reply

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