Posted by CK on 10/24/06 19:53

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

[Back to original message]