×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

BOM table relations

BOM table relations

BOM table relations

(OP)
Hi Folks,
I have an assembly of 30 components.
I want to create a bom table in the Z-A format.
Like components have to be started from Z to A. How can write a relation to get this BOM table.

Thanks in advance for your valuable reply.

Regards,
selva

RE: BOM table relations

(OP)
tnx fighter

RE: BOM table relations

(OP)
Yup. Am following the repeat region only. but i want to customize it using relations according to my requirement. the exxact solution i want is:

1.1 :First N number of BOM items shall be only Standard parts (Parts that have P numbers or seperate drawing )
Rule 1.2: Within Standard parts, reverse alphabetical order shall be followed in sorting

Rule 2.1  After standard parts, the stock cut (No machining) components are grouped as follows (following reverse alphabetic order)
   Z
   Y
    .
    .
   Round Bar
   RHS
   Plate

Rule 2.2 : Within each component group, the following sequence shall be followed
              Largest  in dimension wise
              ....
              Smallest in dimension wise

Rule 2.2.1
               For Round bars – Diameter is the measure of size, sorted in descending order
                                             For Same diameters, then sorted by Length in descending order
             
                             
Rule 2.2.2
               For RHS -   Width X Height   is the measure of size, sorted in descending order
                                   For same Width X Height , then sorted by length in descending order
Rule 2.2.3:
               For Beams - Width X Height   is the measure of size, sorted in descending order
                                    For same Width X Height , then sorted by length in descending order
Rule 2.2.4 :
            For Plates – Thickness is the measure of size , sorted in descending order
                                For same thickness, then sorted by   Width X Length   product in descending order.
Rule 2.2.5 :
    Machined plates (for eg.,PLATE T = 10) are placed after the standard plates as above,
 sorted by descending order as per thickness


So i want to use relations in insert---->repeat region

Please provide how to continue with relations.

Thanks in advance for ur reply


 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources