Forms Help Pleeease

[Avslavedriver]

I have a two tables, A record table with a product number, description, and scheduled date of when things should be shipped. I also have a table called fiscal Week with just the fiscal week number, a start date for the week, and an ending date for the week.

Now, i have created a form with a combo box to allow users to select the fiscal week. What i want to happen is to have that combo box link the data to a query that will put a range on my schedule date via the start and end date of that week. The fiscal week value is the primary key of that table.

The two tables are completely unrelated.

Thanks

 

[Andrew Fergus]

Hi, I'm not sure that I understand the problem 100%.

Are you wanting to select a "fiscal week number" in the drop down box, and depending on the start and end dates for that fiscal week (from the "fiscal week" table), you then want to display the items from the "products" table where the "scheduled date" is between the start and end dates for that fiscal week? Is that what you are looking to do?

Andrew.