UD Table Blank Title 67337

Yahoo Archive
1
Hi Melanie



Any time you have a many-to-many you just create an intermediate table
which holds the key fields. For example in your case you might have the
Part table and Specs table(udxx) which are many-to-many. You just add an
intermediate table which could be thought off as partspecs table(udxx).
The partspecs table would contain part number and spec number, not much
more.





Mark Dupuis

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of melanie.kucan
Sent: Tuesday, February 17, 2009 4:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] UD Table



I need to create a many-to-many relationship with a user defined table
and a part. More specifically, I need to attach "specs" to parts. A
part can have many specs and a spec can have many parts. Does anyone
know if this is possible?

I have created the spec table in Vantage and can put an ultra combo box
on the part entry form. However, this obviously doesn't allow me to
select multiple specs for that part. Any ideas?

Thanks,

Melanie





[Non-text portions of this message have been removed]
2
Does anyone know how to call a UD table from another form? I want to
place a button on the quote line item form and call one of the UD
tables passing as parameters the quote and line numbers. Any help would
be greatly appreciated.


Thanks
Kersten
3
I need to create a many-to-many relationship with a user defined table
and a part. More specifically, I need to attach "specs" to parts. A
part can have many specs and a spec can have many parts. Does anyone
know if this is possible?

I have created the spec table in Vantage and can put an ultra combo box
on the part entry form. However, this obviously doesn't allow me to
select multiple specs for that part. Any ideas?

Thanks,

Melanie
4
Use a Parent Child UD table like UD100 / UD100a

The parents would be your Specifications (UD100)

The children would be the related partnumbers that are linked to these
(UD100a)



Regards,

Stephen



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of melanie.kucan
Sent: 17 February 2009 21:10
To: vantage@yahoogroups.com
Subject: [Vantage] UD Table



I need to create a many-to-many relationship with a user defined table
and a part. More specifically, I need to attach "specs" to parts. A
part can have many specs and a spec can have many parts. Does anyone
know if this is possible?

I have created the spec table in Vantage and can put an ultra combo box
on the part entry form. However, this obviously doesn't allow me to
select multiple specs for that part. Any ideas?

Thanks,

Melanie



[Non-text portions of this message have been removed]
5
Thanks. I will try this.




________________________________
From: Stephen Edginton <stephene@...>
To: vantage@yahoogroups.com
Sent: Tuesday, February 17, 2009 3:16:27 PM
Subject: RE: [Vantage] UD Table


Use a Parent Child UD table like UD100 / UD100a

The parents would be your Specifications (UD100)

The children would be the related partnumbers that are linked to these
(UD100a)

Regards,

Stephen

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups ..com] On Behalf
Of melanie.kucan
Sent: 17 February 2009 21:10
To: vantage@yahoogroups .com
Subject: [Vantage] UD Table

I need to create a many-to-many relationship with a user defined table
and a part. More specifically, I need to attach "specs" to parts. A
part can have many specs and a spec can have many parts. Does anyone
know if this is possible?

I have created the spec table in Vantage and can put an ultra combo box
on the part entry form. However, this obviously doesn't allow me to
select multiple specs for that part. Any ideas?

Thanks,

Melanie

[Non-text portions of this message have been removed]


__._,_..___
Messages in this topic (3) Reply (via web post) | Start a new topic
Messages | Files | Photos | Database | Members
Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
MARKETPLACE

________________________________
From kitchen basics to easy recipes - join the Group from Kraft Foods

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Recent Activity
* Â 3
New Members
* Â 1
New FilesVisit Your Group
Ads on Yahoo!
Learn more now.
Reach customers
searching for you.
Y! Messenger
All together now
Host a free online
conference on IM.
Health Groups
for people over 40
Join people who are
staying in shape.
.






[Non-text portions of this message have been removed]
6
We sell industrial valves - each with dozens of specs -all done via UD table records tied to Part (so it is possible).

It can't just be free for all though. Many to many is only really needed if you want some simple key between Part and the UDs to provide much deeper detail (stored in the UDs) to become related to a part (or parts via the key) and to do so in a way that really simplifies long term data maintenance.

What are you specifically trying to do?

Rob

--- Original Message ---
From:"melanie.kucan" <melanie.kucan@...>
Sent:Tue 2/17/09 4:11 pm
To:vantage@yahoogroups.com
Subj:[Vantage] UD Table

I need to create a many-to-many relationship with a user defined table
and a part. More specifically, I need to attach "specs" to parts. A
part can have many specs and a spec can have many parts. Does anyone
know if this is possible?

I have created the spec table in Vantage and can put an ultra combo box
on the part entry form. However, this obviously doesn't allow me to
select multiple specs for that part. Any ideas?

Thanks,

Melanie