limitation of fields in forms
- Thread starter eran185
- Start date
thats 1 big form and 3 big tables
normally (please note normally and not always)
tables should be thin and long and not wide and long
--
now you are trying to fit 600 fields on to a form - mad
give us an idea of whats in the tables as the structures sounds kinda wonky
normally (please note normally and not always)
tables should be thin and long and not wide and long
--
now you are trying to fit 600 fields on to a form - mad
give us an idea of whats in the tables as the structures sounds kinda wonky
thin and long tables (more of them) rather than wide and few
its structuring the data in such a way as long as the references are in place then the rest is pretty easy
each table will have pk (primary keys) and foreighn keys(FK)
its structuring the data in such a way as long as the references are in place then the rest is pretty easy
each table will have pk (primary keys) and foreighn keys(FK)
boblarson
Smeghead
- Local time
- Today, 06:35
- Joined
- Jan 12, 2001
- Messages
- 32,040
I just gotta ask the question, "WHY?!!" It sure sounds like an unnormalized, spreadsheet type database.
As for your initial question - you might be able to use 2 or 3 subforms, depending on your relationships. But, it really sounds like this may need a redesign to make it so it can function in a Relational Database.
boblarson
Smeghead
- Local time
- Today, 06:35
- Joined
- Jan 12, 2001
- Messages
- 32,040
when you say 200 fields, fields in database terminology are columns. So, you actually have four fields. The rows are insignificant. If you want to create a form with four columns (fields) you can do so very easily and you can set the form view to be either continuous or datasheet (spreadsheet-like) to have all of your data show (depending on your form size you'll have to scroll down to see all of the records).
Just use the new form wizard.
Just use the new form wizard.
boblarson
Smeghead
- Local time
- Today, 06:35
- Joined
- Jan 12, 2001
- Messages
- 32,040
I think you need to go through an Access tutorial then. This is simple, basic stuff that you need to know before you go further.
Try out this site:
http://www.functionx.com/access/
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
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
boblarson
Smeghead
- Local time
- Today, 06:35
- Joined
- Jan 12, 2001
- Messages
- 32,040
hey again
i read the lesson ... and now i understand a little more.
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 ?
i read the lesson ... and now i understand a little more.
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 ?
