Modify Access Defaulted Table Creation Fields 1

[MwTV]

Hopefully, this is doable.

Upon selecting "Create table in Design View", the fields
along the top row are "Field Name", "Data Type", and "Description."

Is it possible to add another field such as "Data Source?"

For example, as I type in the field elements of the table, I would like to also specify the data source for the field element in addition to the data type and description.

Thanks in advance.

 

[GingerR]

Hi--can't change the structure. You could either put that info into the Description, or create your own custom table listing the TableName, FieldName and Datasource. I would just put it in the description, myself.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html