|
hi, if i have the following:
NameTable
Name Text(7)
ID int
InfoTable
Name
ID
where NameTable is a bunch of names you can lookup
by id or lookup id's by name and info table is a table which only has "Name"
populated...is there a way to populate ID easily?
i tried this but of course it didnt
work...shucks:
update InfoTable,NameTable set
InfoTable.ID=NameTable.ID where InfoTable.Name=NameTable.Name
any help is greatly appreciated
(: |
