If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
creating a table using variables
I am stumped trying to figure this out and would appreciate any input.
I need to make a table with variable fields based on user input. It seems that there should be a really easy solution but I have yet to figure it out. Thanks in advance, Ray |
#2
|
|||
|
|||
You would need to explain what you want.
Rick B "r_young_81" wrote in message ... I am stumped trying to figure this out and would appreciate any input. I need to make a table with variable fields based on user input. It seems that there should be a really easy solution but I have yet to figure it out. Thanks in advance, Ray |
#3
|
|||
|
|||
I have a form and table for user input to initiallize the database, basically
client name and a number variable. I want to take this number and create a table with a few set fields and fields of the number input, i.e.: User inputs 3 SetField1 SetField2 VarField1 VarField2 VarField3 If the user inputs 4 then an additional field, Varfield4, would be added. Thanks again. "Rick B" wrote: You would need to explain what you want. Rick B "r_young_81" wrote in message ... I am stumped trying to figure this out and would appreciate any input. I need to make a table with variable fields based on user input. It seems that there should be a really easy solution but I have yet to figure it out. Thanks in advance, Ray |
#4
|
|||
|
|||
You are still not really telling us what you are doing, but...
This sounds like a classic one-to-many relationship. You would create a new table for the variable(s) and it would have two fields: Client number (which would match your client table) and variable. If the user needs one variable, they would create one record. If they need ten, they would create ten records. In a form, this would be represented as a continuous subform. I'm pretty sure there are samples of this type of setup in the Northwinds sample database. You might look at how it handles invoices and invoice detail lines. Classic one-to-many. Rick B "r_young_81" wrote in message ... I have a form and table for user input to initiallize the database, basically client name and a number variable. I want to take this number and create a table with a few set fields and fields of the number input, i.e.: User inputs 3 SetField1 SetField2 VarField1 VarField2 VarField3 If the user inputs 4 then an additional field, Varfield4, would be added. Thanks again. "Rick B" wrote: You would need to explain what you want. Rick B "r_young_81" wrote in message ... I am stumped trying to figure this out and would appreciate any input. I need to make a table with variable fields based on user input. It seems that there should be a really easy solution but I have yet to figure it out. Thanks in advance, Ray |
#5
|
|||
|
|||
To initiallize this database, the user inputs the client name and the number,
which will be the number of fields added to a table that needs to be created and that has 2 set fields (will always be present with any input value). I want to take that input number, X, and add X fields to table Y. Such that if the client put in 3, a table would be created with 2 constant, predefined fields, and 3 added variable fields. User input 3: SetField1 SetField2 VarField1 VarField2 VarField3 I assume that VB scripting would be the easiest way to create the table. Hope this clarifies my needs a bit better. "Rick B" wrote: You are still not really telling us what you are doing, but... This sounds like a classic one-to-many relationship. You would create a new table for the variable(s) and it would have two fields: Client number (which would match your client table) and variable. If the user needs one variable, they would create one record. If they need ten, they would create ten records. In a form, this would be represented as a continuous subform. I'm pretty sure there are samples of this type of setup in the Northwinds sample database. You might look at how it handles invoices and invoice detail lines. Classic one-to-many. Rick B "r_young_81" wrote in message ... I have a form and table for user input to initiallize the database, basically client name and a number variable. I want to take this number and create a table with a few set fields and fields of the number input, i.e.: User inputs 3 SetField1 SetField2 VarField1 VarField2 VarField3 If the user inputs 4 then an additional field, Varfield4, would be added. Thanks again. "Rick B" wrote: You would need to explain what you want. Rick B "r_young_81" wrote in message ... I am stumped trying to figure this out and would appreciate any input. I need to make a table with variable fields based on user input. It seems that there should be a really easy solution but I have yet to figure it out. Thanks in advance, Ray |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Manual line break spaces on TOC or Table of tables | Eric | Page Layout | 9 | October 29th, 2004 04:42 PM |
Unmatched Query Mess | Natalia | Running & Setting Up Queries | 8 | October 28th, 2004 02:36 PM |
Automatic filling of fields in table two from table one | Jim Kelly | Database Design | 1 | September 27th, 2004 10:16 PM |
Autonumber | Ally H. | General Discussion | 7 | August 27th, 2004 04:51 PM |
Semicolon delimited text query help | Al Guerra | Running & Setting Up Queries | 3 | August 12th, 2004 11:50 AM |