Design Issue: Custom Property?

[Stan Denman]

I have created a database I use to manage my legal client matters. I am seeking to use the MS 2010 Access database to automatically populate on-line forms. In populating the on-line forms, each field in my DB essentially has a different field name than that required for the on-line form. So, for example, field FirstName in my Access DB is "BE_CASE_FNM" in the online form. I can create a CSV file from Access to populate the form where the header is the on-line form field name. So I would need to create a CSVfile where the value is that of FirstName in my DB with a header name of "BE_CASE_FNM". In considering a solution, I could simply rename every field in my DB to that of the online form. I was also wondering if I could create a custom property for each field that is the "alias" name required in the online form. Any help would be most appreciated.

[orange]

I don't have acc2010, but could you explain more of your intended process.
My first question is, "Why are the names as different as they are - since you created both"?
Where does the csv file fit in?
You could rename the table field by using an alias

Select FirstName as BE_CASE_FN,..... from myTable

and use the select query as the recordsource of the form.

[Stan Denman]

For the on-line form completion I am using a product called "Form Auto Fill". It creates the forms from the on-line forms. I guess it takes the names of the fields in the online forms. To fill the online forms I can update from a CSV file where as I say the header names must correspond to the online form names. The DB, of course, was something I created over the past few years.