Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2025
    Location
    Near Indinanapolis IN
    Posts
    11

    Relationship concept

    Hi,



    I decided to use access to create G-code for my four (so far) CNC routers and I'm haveing trouble envisioning the relationships between the machine, the tool dims and the tool tables in the that exist within the machines.

    ToolQty by machine
    Onsurd 12
    Omni 8
    Stile 20
    DB_CNC 8

    There are tool racks on each in this quantity. When programming I must tell the machine what tool to pickup (physical location like T12 is the 12th position on the Onsurd) and it's related tool number in it's inteternal tool table (like G43H12). G43H is the G-code instruction to go look at this internal table and return the measured tool height. The G43H internal table is up to 99 and stores the tool height of each tool record. Usually the T number and the G43H number are the same so the code would be T12:G43H12 but not always. Sometimes the tool normally in a position is substituted by another tool for a special task and in that case the instruction would be T12:G43H32 where the G43H has been measured and recorded in T32 in the machine tool table.

    As an example on the Onsrud the saw tool would normally be 12 and I'd call T12:G43H12. It would pick up the saw and set the height according to the prerecored internal tool number 12. However, I might put a planer tool into fork 12 with it's prerecoreded G43H number of 22 so the code would be T12:G43H22.

    I need to write the Access program to recognize the correct tool number and it's corresponding G43H number for each machine.

    So, I'm pictureing tbl_Machine>tbl_ToolDims with a lookup table tbl_ToolTable with maybe MachineID, ToolID and G43H number. Is this correct or how would you suggest relating this information?

    Ideas/suggestions?

  2. #2
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,819
    Hi

    I believe this can be achieved by means of Cascading ComboBox's.

    1st Combobox allows you to select a Machine
    2nd Combobox would allow you to only select Tools associated with the Machine Selected
    3rd Combobox would also only allow selection of G43H number associated with the specific Tool selected.


  3. #3
    Join Date
    Apr 2025
    Location
    Near Indinanapolis IN
    Posts
    11
    Yes, see email I just sent you.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 12-06-2014, 12:49 PM
  2. Cumulative Limit Concept
    By Bedsingar in forum Access
    Replies: 5
    Last Post: 07-29-2011, 06:32 AM
  3. Contract letter concept
    By siktir23 in forum Access
    Replies: 3
    Last Post: 07-22-2011, 12:07 PM
  4. Report Concept
    By BLD21 in forum Reports
    Replies: 1
    Last Post: 07-03-2011, 09:44 AM
  5. Concept Forms
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-31-2010, 01:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums