T
Tandy
OK, you know how when you open the Form Wizard it brings up a form with a
combo box to pick a Table or Query, a list box called "Available Fields" and
another called "Selected Fields" with button in between to move the fields. I
would like to do something similar to that. I would like the "Available
Fields" box to display a field called "Doctor's Initials" from my table
called "Doctors". I would then to be able to move certain doctors with the
buttons to the "Selected Fields" box and enter all of them in a table called
"Pay Group" with one Pay Group number and Date Assigned. The Pay Group Table
has the fields Doctor's Initials, Pay Group and Date Assigned. The table
looks something like this:
Doctor's Initals Pay Group Date Assigned
SAR 1 1/1/2005
GHF 1 1/1/2005
JKL 1 1/1/2005
Any and all help will be greatly appreciated!
combo box to pick a Table or Query, a list box called "Available Fields" and
another called "Selected Fields" with button in between to move the fields. I
would like to do something similar to that. I would like the "Available
Fields" box to display a field called "Doctor's Initials" from my table
called "Doctors". I would then to be able to move certain doctors with the
buttons to the "Selected Fields" box and enter all of them in a table called
"Pay Group" with one Pay Group number and Date Assigned. The Pay Group Table
has the fields Doctor's Initials, Pay Group and Date Assigned. The table
looks something like this:
Doctor's Initals Pay Group Date Assigned
SAR 1 1/1/2005
GHF 1 1/1/2005
JKL 1 1/1/2005
Any and all help will be greatly appreciated!