Recent content by lironh

three tables How do I implement the three M-M tables? please rememmber that I'm trying to make here a M-M relationship for the same table ... 'OriginComponentID' should be connected to 'ComponentID' in order to know from where is the component was duplicated from, and 'ComponentID' should be...

Hi All, I'm trying to create a form that is reading filenames from a certain folder on my computer. The filenames have some prefixes - 'tu' , 'tc' , 'bf' , 'tf' and 'act'. each filename that is read is being displayed (without it's prefix) in a list and has another attribute (type) that the...

Have you succeeded? Hi dearsina, have you succeeded ? I'm trying to program a similar hierarchy here...

anyone ? PAT ? Do you have any reply to my last question ?

New optional direction Hi ... I've decided that due to the similarity of 'Actions', 'TestCases' and 'Test Flows' that i'll put them all in the same table with another field of their type (0=action, 1=test case, 2=test flow) and with another 'types' table in order to know the name of the type...

double table Hi Pat, I've addede all the relationships but when I've added the testCase to testCase relationship I got two same tables (the second with _1 suffix) - is it what you intended to do by connecting a table to the same table ?

thx Pat But how do i make the specific query I need to get the fathers of each hierarchy level component ?

well ... Currently I have the tables: 1. 'Actions' with the fields - 'actionID', 'actionName', 'codePath' 2. 'Test Cases' with the fields - 'testCaseID', 'tcName', and it need to have an 'actionsID' and 'usedTestCaseID' field but i'm not sure how to create it... 3. 'Test flows' wth the fields...

hehehehe Hi Pat, Well ... as a matter a fact it's a Staj i'm doing and not getting paid for it and this app is a very (very) small part of my Staj. Sure I need a direction here but I think that doing some tables in access is very easy and we're talking about 3 maybe 4 tables ... :D I would...

Hi all, I'm a newbie in access and i'm trying to make a small application in access that will have the following functionality: - The user of the app can add new 'test flows' which can include 'test cases' and 'actions'. - 'test cases' can include 'test cases' and 'actions' - 'actions' are...