473,320 Members | 1,872 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Having trouble with seeing form in design view

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
1 1641
Stewart Ross
2,545 Expert Mod 2GB
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

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

Similar topics

2
by: Ray | last post by:
Stop me if you've heard this, but I am running Access 2002 and all of a sudden, if I design a particular form (it's been working fine for ages), Access crashes rather than open it in design view. ...
9
by: Lyn | last post by:
Hi, I have a form which is opened from a button on another form. The form is used to display a list of records from a recordset in Continuous Mode. It is sized vertically to display about 25...
6
by: Terry | last post by:
I have a very basic program, but for some reason I can't get it to behave properly. What I want is a basic form with a TabControl that fills the entire form. The tab control should have 4 tabs...
14
by: Jan Nielsen | last post by:
Hi In Microsoft Access it is possible to write code like this Sub test() DoCmd.OpenForm "TestForm", acDesign Dim a As Control For Each a In Forms("TestForm").Controls Do stuff Next End Sub
8
by: Brett | last post by:
I have a form with a Form1_Load() Subprocedure and no other code. For some reason, the design view does not come up. If I add a new form, the design view does come up. The form does appear when...
18
by: fishwick | last post by:
I haven't really done any css in quite a while, and am banging my head against the wall trying get the rudimentary layout together of a church website home page to display correctly - I don't want...
3
by: mckbill | last post by:
Is there a way I can direct the cursor to a specific field (variable) in a form by typing the field name while in form view? I have a form with many fields, and it would be nice if there were...
3
by: Bobby Edward | last post by:
I had a simple admin form for "Categories"... Details View: To INSERT new Category Grid View: To View, Edit and Delete all Categories I decided to put the INSERT Details View inside of a...
5
matheussousuke
by: matheussousuke | last post by:
Hello, I'm using tiny MCE plugin on my oscommerce and it is inserting my website URL when I use insert image function in the emails. The goal is: Make it send the email with the URL...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.