Advice needed about making forms.

  • Thread starter Thread starter albertoocdc
  • Start date Start date
A

albertoocdc

Hi

I´m quite new in Access. I have a problem.

I don´t know how to implement a form with "n to n" relationships. I
explain:

One table with Business offers and another onw with Technologies. One
Offer can be related to N Technologies, and one Technology can be
included in N Offers.

What's the best way to implement that in a form? I don´t find any easy
way of doing it. I imagine two ListBoxes (one with the Technologies
related to the Offer displayed in the form and another one with the
rest, and some buttons to pass Technologies from one List to another).

Is this the best way of doing it?

Thanks in advance
 
One of the most common approachs is to have a form/subform set up. Take a
look in the Northwind database that comes with Access. The Orders form
(which uses the Orders Subform as its subform) is an example of how they use
the Order Details table to resolve the many-to-many between Products and
Orders tables.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Hi

I´m quite new in Access. I have a problem.

I don´t know how to implement a form with "n to n" relationships. I
explain:

One table with Business offers and another onw with Technologies. One
Offer can be related to N Technologies, and one Technology can be
included in N Offers.

What's the best way to implement that in a form? I don´t find any easy
way of doing it. I imagine two ListBoxes (one with the Technologies
related to the Offer displayed in the form and another one with the
rest, and some buttons to pass Technologies from one List to another).

Is this the best way of doing it?

Thanks in advance
 
Back
Top