Devam Ediyor

196953 Access 2007 Project

Hello there,

i have created a database with some forms in Access 2007 and the problem i have is the following.

I have 3 tables with the following fields

Categories

[url removed, login to view] / Categories

Products

[url removed, login to view] / Product / [url removed, login to view](lookup field)

This means that every product belongs to a category, in other words every value in the table products is linked with one value from the table Categories!

The third table is

Listings

[url removed, login to view] / Listing_Title / [url removed, login to view] (Listing_Categories, which is a combo box allowing more than 1 value from the categories table) / [url removed, login to view] (Products, which is a combo box allowing more than 1 value from the products table)

After the structure of the database i ll describe it to you in order to make it more clear what i want.

I want to be able to insert new records in the Listings table and for every listing to be able to choose many categories from the combo box, and in the product combo box filter only the products that belong to the categories i have chosen for this record. Let me give you a small example...

In a new record i select 2 categories from the combo box of categories, which are Football & Basketball. I want in the products field to filter and bring, as availiable to choose, only the records that refer to these 2 categories.

I suppose that this operation can be controled in the form controls and not in the database structure. So i need someone to be able to handle the form controls in order to do this relation between controls.

:)

Finally i have attached the database that i have described to make it easier to understand the project.

Please ask me for any questions

Beceriler: Her şey Kabul, Microsoft Access

Daha fazlasını görün: what is microsoft project, microsoft words, described structure, access order, linked project, access linked table, access 2007 linked table, football questions, questions basketball, access form record, table linked access, record lookup, table controls, football project, database products filter, form access project, table filter, access project database, access table lookup, football database project, lookup table access, basketball database, product order table, small database access, need database football

İşveren Hakkında:
( 10 değerlendirme ) Athens, Greece

Proje NO: #1943174

Seçilen:

neethe

i can help you to getit done. as explained in PMB.

3 gün içinde 100$ USD
(51 Değerlendirme)
6.2