>>>Help, I am trying to add new records to a grid. When selecting my new button I would like to have one of the columns default to certain unquie numbers. Anyone have any ideas on how to do this?
>>>
>>>Thanx
>>>
>>>Holly Clawson
>>
>>1) Add the function to generate the unique number (or whatever) as a Stored Procedure in your DBC.
>>
>>2) Add a Default Value to the field that calls the function you just created.
>>
>>-Doug-
>
>I have that function already. Maybe I need to explain this I have three tables on this form when add a new record, the parent table creates the unquie ID. I use the grid to enter the customer rate information. Every customer will use the same four location numbers. I need the location numbers to appear in the column. These numbers are not unquie IDs.
>
>Holly

Can't you take care of this with the other suggestings re: INSERT INTO using the parent table's "location number"?

-Doug-