Having trouble with seeing form in design view

[Tableshavturned]

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.Th e 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

[Stewart Ross]

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