Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: PaganBilly
- Order by date
-
Lookup wizard
Why is it that whenever I use the lookup wizard to take values from a table, the fieldname changes to the same name as the one in the lookup table? I want to be able to use the same table of values for several fields so I need them to retain their original field names. Is this possible, or do...- PaganBilly
- Thread
- Replies: 1
- Forum: Microsoft: Access Tables and Relationships
-
1 to 1 tables for large number of fields
Most of the data consists of test results. I am trying to categorise the fields such that each table has 100 to 200 items. Also, some of the data is about events which happen up to 4 times. In these cases, I am putting event1, event2, event3 and event4 fields into seperate tables, so that the...- PaganBilly
- Post #3
- Forum: Microsoft: Access Other topics
-
1 to 1 tables for large number of fields
I am developing a database with 1000 records. For each record I will be storing about 4000 items of information. It is effectively a flat database and my planned structure consists of one master table with several (20+) 1 to 1 related tables. I am concerned that I will hit the limit for the...- PaganBilly
- Thread
- Replies: 4
- Forum: Microsoft: Access Other topics
