In this tech tip you will learn how to use PropertyLinks Professional to filter a Finish or Heat Treat based on the selected SolidWorks Material.
- SolidWorks 2007 or above
- PropertyLinks Professional V4 or above
- Database editing application (example Microsoft Access or SQL Server)
- A working knowledge of the database application (in this example we are using Microsoft Access)
Setting up the Supporting Database
- Create a new database
- Note: if you have an existing database that you would like to use you can add a new table to the database
- In this example I am creating a new Access database called “PropertyLinks Professional Supporting Database.mdb”
- The database can be saved anywhere on the network as long as it is accessible by all the SolidWorks users, in this example it is saved in the same folder as the PropertyLinks dataset.
- Open the database
- Create two new tables in the database called “Finish” and “Heat Treat”, as shown below in Figures #1 & #2
- Populate the table with valid data for your company (examples in Figures #3 & #4)
Setting up PropertyLinks Administrator
- Open your PropertyLinks Dataset in PropertyLinks Administrator.
- Go to Tools, Options in PropertyLinks Administrator and ensure that the “Use Database Connections” option is checked. See Figure #5 below
- Create Finish and Heat Treat Properties
- If the Finish or Heat Treat properties exist delete them
- On the Properties tab press Insert to add new properties
- Make sure the “Type” is “Database Connection” (see Figure #6 & #7)
- Go to the Database tab in PropertyLinks to setup the connection.
- Edit the Finish Property and set it to point to the Finish table and the Finish field (see Figure #8)
- Press the Test Database Connection button (in the bottom right corner), note it returns all the Finish records in the table. Note duplicate items are automatically removed form the list
- Now we want to filter it based on the selected material, to do this we pick the Add Filter button
- Set up the Where Field Filter as shown in Figure #10
- Note the “Test String” field is only used in PropertyLinks Administration to “Test Database Connection”
- If we now press the Test Database Connection button again we now see that the list is filtered to only finishes that apply to “6061 Alloy” Note 2 items were removed from the database
- Set up the Heat Treat Property as shown in Figure #12.
- Test the connection to make sure it works properly.
- Make sure you have the Finish and Heat Treat Properties added to the Pages
- Save your PropertyLinks Dataset.
Inside SolidWorks (from a user perspective)
- Start SolidWorks
- Make sure that the dataset that you modified is loaded, this is done through the PropertyLinks Options inside of SolidWorks
- Try it out on a SolidWorks Part