>I can't think through how to set up user defined fields, like you see in a Personal Information Manager, such as ACT. I have an address database, and I want the ability for someone to define a field, such as AGE or GROUP SIZE, so that they can enter additional customized information. The fields would be inputed on a form, displayed in reports, and able to select in a query.
>
>I'm using VFP 7 and Visual Promatrix 7. I am not looking for VPM procedures specifically.
>
>Can anyone give me some ideas for doing this?
>
>Mike Bollinger
>Foxpro Hobbyist
User defined fields ? I think in VFP all fields in a table are user defined unless it's a table like scx, vcx, frx etc.
To add a new field you could use 'alter table' command. ie :
alter table myTable ;
add column Age i ;
add column GroupSize i
PS: Age doesn't sound to be a good field. I'd have BirthDate instead.
Or do you mean a calculated field ? If so say for age on form :
Add a textbox and set :
Enabled : .F.
DisabledForeColor : 0,0,0
ControlSource : (year(date()) - year(myTable.Birthdate))
Cetin