simple forum question

[Michael Sainz]

Hey all,
I'm building a test order form and I have three tables in a SQL
database. Orders, OrderDetails, and Products. When I build the Main Data
Connection, I can link Orders and OrderDetails...but when I try to link
Products, I get a Many to One relationship might exist.

As I understand, there really isnt a way around this other then coding
through scripts or managed code, so if someone could just give a brief
overview, I think I could figure it out.

Thanks!

 

[Alex [MSFT]]

What kind of form are you trying to create? If your form is about allowing
customers to create a new Order (thus, filling out a new record in the
Orders and Order Details table), then you only need Orders and OrderDetails
in your main data source. I am also assuming that inside an order you can
pick one or more products. If this is the case, just pull in the Products
table as a separate data source, and populate one of your dropdowns with
data from it.

Good luck,
Alex @ Microsoft

 

[Michael Sainz]

Alex,

Thanks for the reply. I should have told you that the Products table has
about 10,000 entries and that is just beginning. There will be more. As I
understand it, when you have a secondary data source, it grabs all of the
data at once and this takes awhile. Add drop down menus in a repeating table
and you get a whole lot of lag when adding new order line (OrderDetail
records). Any suggestions or need more info?

Michael

 

[Scott L. Heim [MSFT]]

Hi Michael,

By chance are your products "categorized?" If they are, what you could do
is add an initial drop-down box to allow the user to select a category and
then populate the products drop-down box with only those products that
match the category.

I hope this helps!

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.