Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
Welcome to the skill header Forums. You can ask questions, get help, or help other members out. Join our Forum for free.
Notifications
Clear all
Dec 13, 2024 3:56 pm
I have noticed that Skillheader uses SQL statements in virtually in every instance, such as opening subforms, dropdown fields and more. Can you provide an insight as to why this is? I am curious as I am more old school and prefer using queries and dedicated forms/tables to edit for drop downs for most occasions that a system admin can control and change overtime. As I am not savvy in the workings of deploying a database using SQL servers, I am wondering if SQL statements make this easier to integrate.
Please give us your take on this subject, we w2ould love to know.
2 Replies
Jan 09, 2025 2:21 am
Do you have any example from the project? Please share so it can be more precise.
Jan 13, 2025 5:11 pm
Sorry, I got waylaid in enhancements. Here is one example;
New Po Sub Form: Record Source:
SELECT tbl_PO_items.POItemsID, tbl_PO_items.POID, tbl_PO_items.ItmID, tbl_Items.ItmNm, tbl_PO_items.ItmQty, tbl_PO_items.ItmPrice, tbl_PO_items.ItmTotal FROM tbl_Items INNER JOIN tbl_PO_items ON tbl_Items.ItmID = tbl_PO_items.ItmID;
