Empty form Problem?

[Asle]

Hi,
i am using ms access 2000.

I have 3 tables called tblJob, tblPrint, tblDesign with one-to-one relationship.
I haved divided into different tables since i dont want to have too many fields in a single table.

tbljob:

JobID - PK
PrintID - FK1
DesignID - FK2
JobDesc
JobNo
JobDate
TotalCost

tblPrint:
PrintID - PK
InkFront
InkBack
GSM
PrintCost

tblDesign:
DesignID
Minimal
Retail
Quantity
DesignCost


The problem i have is, when i tried to create a form that includes all fields from above tables using a wizard , i get an empty form.
but when i switch it to design view,i i could see all fields.

why i could not see all the fields in form view?

can anyone help me , please.

chuz,
Asle

[damonreid]

Make a query to join the 3 tables check your join type it should be an outer join.

However I would simple make a single table, how many fields are you talking about here?

[Asle]

Make a query to join the 3 tables check your join type it should be an outer join.

However I would simple make a single table, how many fields are you talking about here?

Hi,

thanks for your reply.

one the whole, i have something close to 100 fields.
so that is why i have divided into 3 tables.

in the relationships, i have selected the join type 3 (right outer join).

but still it is showing an empty form..

i created a query that includes all these fields and tried to create a form using wizard.
but when i selected the query in form wizard, it is not showing any fields to select to create the form.

i dont know where i went wrong.

I appreciate your help in this regard.

thanks,
Asle

[damonreid]

A simple solution may be to have a single table with your "key" on it and make the other tables have the same key as a look up. That way you will have a series of unique numbers in one table to form your query.

Don't use the query wizzard for this, simply open a new query in design view. Add the 3 tables and make your initial table the right hand join to all the other tables (depending on your personal layout).

I think the field limit in Access (2003) is about 175 fields though, 100 shouldn't be much of a problem speed wise.

[Asle]

A simple solution may be to have a single table with your "key" on it and make the other tables have the same key as a look up. That way you will have a series of unique numbers in one table to form your query.

Don't use the query wizzard for this, simply open a new query in design view. Add the 3 tables and make your initial table the right hand join to all the other tables (depending on your personal layout).

I think the field limit in Access (2003) is about 175 fields though, 100 shouldn't be much of a problem speed wise.

thanks damon.

thanks for your help.

I got that working. actually, i have to create another db which has more than 200 fields. i was bit scared what i am gonna do when i started to work on it.

lemme finish this first and take one step at a time.

thanks again for your reply.

chuz,
Asle

[Tableshavturned]

Hi this is my first post on the forums, it took me a while but I finally found something close to what I was searching for on the access forums close to the issues I am encountering. I haven't really developed before with Access 2003 so trouble shooting with this application is not my forte. The issue at hand is pretty similar to Asle, but I sort of did the recommended answer by creating 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

.

[Tableshavturned]

(BUMP) I know this is an old thread but need some input quick....thanks