|
|
Posted by rhaazy on 10/24/06 21:52
Perhaps if you included a bit more information, a psuedo example of
information in the tables would help a little.
CK wrote:
> Hi All,
>
> We have a budgeting table and a budgetAssistant table, I have 3 employee ID's,
> I need to assign each of them as budget assistant. Do you know of a quick
> update query I could write to accomplish this? The budget and
> budgetAssistant tables both have a budgetID field. Any ideas?
>
> I wanted to select those employees, then select all the budget then loop
> through and add those 3 to each budget as a budgetAssistant.
>
> Thanks,
>
> ~CK
Navigation:
[Reply to this message]
|