Modifying a record layout

[JJT]

Is there a way for me to use code or a query to add fields to an existing record layout ?

Thanks

 

[Chris RR]

Are you permanently trying to change the table layout, or do you just want to create some new fields on the fly, for use in a report or query?

If you want to permanently change the layout in code, I'd ask why. With a good data design, you should not need to do this.

Can you give an example?

[This message has been edited by Chris RR (edited 03-28-2001).]

 

[JJT]

I will be importing tables which need to have additional numeric fields added to them on the fly before I can use them for calculations.

 

[Chris RR]

You could build a main table in a format that would have all fields in it. Then import your tables and append their data to the main table. Finally, run an update query to fill in the numeric fields.

But you've probably thought of that already. Are these fields that you can't define ahead?

 

[JJT]

I did not think of that. I can create a table
template with all the fields, then append the
new table into the template.

Easy is always better.

Thanks