limitation of fields in forms

[eran3185]

hey
i have 3 tables , every table has almost 200 fields.
i want to build a form that include all 3 tables
how can i do this ??

[OBP]

eran, I am not sure how someone will assimilate around 600 fields of data but this is how you can do it.
Create queries that break each table down in to groups of related fields, maybe 40- 50 per query.
Create a Subform from each of the queries and one Main form.
On the Main Form add Tabbed pagesform the Toolbox, 1 for each of your subforms.
all the fields can then be accessed by a single click.

[eran3185]

i think that i wasnt clear.

i have 4 fields , but the user need to put his data on 150 lines , so i need that the table and the form will contain 150 lines .
if there is only 4 fields - the data will "trample" the former data.
i need "place" for all the data (150 X 4) fields

the user want to see all the information (150 X 4) fields in the form

[OBP]

Assuming that the fields are type "Memo" then you can make the 4 fields as large as possible on the form and then set the forms Field to Vertical Scroll Bar. So all the data will be able to be viewed.

[eran3185]

i have 2 tables , the big one contain alot of fiels (name , phone num , address etc...) .
the key is the number of the deal.
and small one that contain 4 fields (every deal has 150 lines of bookkeeping .
it's look like :

Credit debit date details

100 50 2/5/07 asasas
200 3/5/07 adsad
123 5/5/07 werwer

i build a form that contain the 2 tables but the problem is that i need 2 keys in the small table (there are 150 lines) .
how can i linked the small to the big table ?

[OBP]

eran, can you post a zipped copy of the database with a couple of dummy records in it?

Providing that you have the Relationship set up correctly between the 2 tables using number of the deal you should actually be using 2 forms.
The big one as the Mainform and the small one as a Subform on the Mainform, linked together by the Number of deal.

[eran3185]

thank's
there are 4 table : the big one and 3 smallest (3-5 fields)
i have a problem to linked all the tables into the form.

[eran3185]

oops , i think i forgot the file

[eran3185]

why i cant see the att file ?

[OBP]

eran, did you Compact & Repair the database and then Zip it before "Uploading" it?
There is a limit to the File sizes allowed on the Forum.

[eran3185]

it was rar file - 210 kb.
the zip is 1.83 mb

[eran3185]

i have a big table that contain general deatails.
the p.key is "number of the deal".
i also have litlle table that contain 4 fields (every deal has 150 lines of bookkeeping .
it's look like :

Credit debit date details

100 50 2/5/07 asasas
200 3/5/07 adsad
123 5/5/07 werwer

if the p.key will be "number of the deal" its not good because there are many lines in every deal (150 lines) ' so i need another key ie - number runner , but i dont know how to linked the small table to the bigest

[geekgirlau]

eran, you'll need to create a smaller version of the database to attach it. All we need is a few sample records for each of the tables that relates to your question, and the form/subforms. Anything not directly related to your question can be removed from this sample database. That should allow you to reduce the size enough to zip and attach a sample.