I will try and be as brief but as descriptive as possible.
I am writing a DB for my friends and I to use for our fantasy hockey league. All the tables and calculations are done. I am not designing forms, but this is where I get stuck.
I get daily stats which I format in excel and import to Access. I breakdown this information into tables based on position. I also append new players and team changes to a table called player assignment. This table only has player, position, team and a UID, which is the primary key. There is one more field here called player asssignment which is "Avail" by default. Here is where I get stck. Each person in the league that owns a team will have their own form. On this form I wish to have a drop down box that shows all players from the player assignment table and their status be it avail or other wise. If selected I want the avail field on the table to show that they belong to that owner.
Problem is, when you link a combobox to a table via a query, it changes the current name on the table to whatever you select. I just can't seem to figure it out. What am I missing? Please help!
Adam
I am writing a DB for my friends and I to use for our fantasy hockey league. All the tables and calculations are done. I am not designing forms, but this is where I get stuck.
I get daily stats which I format in excel and import to Access. I breakdown this information into tables based on position. I also append new players and team changes to a table called player assignment. This table only has player, position, team and a UID, which is the primary key. There is one more field here called player asssignment which is "Avail" by default. Here is where I get stck. Each person in the league that owns a team will have their own form. On this form I wish to have a drop down box that shows all players from the player assignment table and their status be it avail or other wise. If selected I want the avail field on the table to show that they belong to that owner.
Problem is, when you link a combobox to a table via a query, it changes the current name on the table to whatever you select. I just can't seem to figure it out. What am I missing? Please help!
Adam
