Form problem

[DPG]

Hi



I created a DB last night with 4 tables, each of which had a relationship linked. When I created a form, the header was visible but the data in the details window couldnt be seen. Not sure why. Any ideas?

Cheers

[RuralGuy]

That usually means there are no records in the RecordSource of the form.

[DPG]

That usually means there are no records in the RecordSource of the form.

Thanks, so would I have to input 1 record in datasheet view then it should appear?

[RuralGuy]

What have you set as the RecordSource of the Form? It is on the Data tab of the property sheet for the form. If it is a table, does the table have any records?

[DPG]

i shall have a look later and let you know. Thank you.

[DPG]

What have you set as the RecordSource of the Form? It is on the Data tab of the property sheet for the form. If it is a table, does the table have any records?

I checked the RecordSource and it links to a table. I am not sure which one I should be choosing and yes it did have a record in it, but still didnt show in form view. There are quite a few fields, so maybe there were too many.

As an alternative, I created just one table instead of 4 and had all my fields in there. This worked better. It was frustrating it didnt work with 4 tables.

[RuralGuy]

I think you would benefit by getting your 4 table system working with a query. You have a few things to learn in this area and this is a good starting point. If you bring up Access Help and ask for Specifications you will start to understand some of the limitations such as 255 fields in a table.

[DPG]

I think you would benefit by getting your 4 table system working with a query. You have a few things to learn in this area and this is a good starting point. If you bring up Access Help and ask for Specifications you will start to understand some of the limitations such as 255 fields in a table.

Thanks for your reply, so am i better off to have it all in one table or still use the 4? I want the user to input the data as simply as possible as produce reports from it. I cant see why i really need 4 tables. There are definitely less than 255 fields in the table.

[RuralGuy]

Have you done any reading on Normalization yet? That is really what dictates the number of tables needed in any particular situation.

[DPG]

Have you done any reading on Normalization yet? That is really what dictates the number of tables needed in any particular situation.

no, where do i find that?

[RuralGuy]

Here's some start links:
http://support.microsoft.com/kb/283878
http://www.phlonx.com/resources/nf3/
...Google knows a lot more.

[DPG]

Here's some start links:
http://support.microsoft.com/kb/283878
http://www.phlonx.com/resources/nf3/
...Google knows a lot more.

Thank you. I will have a look over the weekend. Its all good fun.....i think. all because I want to set up a side line business building dbs for very small businesses.

[RuralGuy]

Enjoy the read.