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!

access table with static fields

Status
Not open for further replies.

edgarv

MIS
Jul 25, 2003
248
US
Hello, I am working on building a form that has 7 columns. 3 of those colums have static text and 4 have text that needs to be entered. how could I build a table for this form.
I forgot to mention that the static text uses about 55 rows. so my problem is that if I were to build a table with all the fields it would take about 55 x 7= 385 and access only hosts 255 am I doing thing the right way?
 
displaying the data in a form has nothing to do with the way the tables are structured. have you read the link below?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top