Search results for query: *

I have three tables with one to many relationships: Customer table Products ordered table Customer ---> prod1 prod2 prod3 customer table locations table Customer ---> location1 location2 location3 I...

thanks LArs7, I will do that

I have three tables with one to many relationships: Customer table Products ordered table Customer ---> prod1 prod2 prod3 customer table locations table Customer ---> location1 location2 location3 I...

thanks Phv, it's a little too much for my level of knowledge, isnt there an easier way? like to build a query with an expression? thanks for your help.

I have the following table. Client Store Products 1 houston shirt 2 austin jeans 3 dallas pijamas 2 austin socks 2 austin Sandals 3 dallas shoes I need to write a query in Access that will...

well, that would mean to have a sequence for each master record wouldnt ?

I have a child (detail) block in tubular form. I need to have a field that will number the regults after the master is queried. ie. MASTER = company details= employees details block looks like this: NUMBER | NAME | LAST_NAME |ADDRESS 1 2 3 4 so I need that for every record on the...

I have a master table (contracts table) with about 20 variables. (about 20 records/ contracts in it) the records are static, they only chage once every 5 years. The idea is that a user queries a customer, if the customer does not have a contract assigned to him/her, the user will open a LOV...

I have actualy done it by creating an insert query from access. Access will do the code for you, its very simple, see the help file "insert queries" the only thing you will need to have is an ODBC connection setup to your orable tables with your host string name and have the tables linked in...

got it, I just found out that rapid sql can let you copy and paste the results as displayed. thanks so much for your input.

GREAT! I WAS ABLE TO RUN THE FOLLOWING QUERY: select * from ALL_TAB_COLUMNS where owner='APPRENTICE' NOW THE ISSUE IS: WHO CAN I DISPLAY THE COMMENTS OF EACH VARIABLE? THAT COLUMN DIDNT SHOW IN THAT QUERY. THANKS!

ok, what else can I retreive with the describe command? and is there anyway to export those results out to a spreedsheet?

What do you mean Sem? I dont know exactly what I can and cannot see. i know I can run describe to any of my tables, ( the ones I own in my instance) that is why I asked you what other queries I can run to see what else is there. I was planning on using the info that the describe command gives...

thanks SEM, well that is exactly why I need to create my own cause I dont have access to the DBA views. SantaMufasa, 1) What does the "Name" column contain? (Table Name, Column Name, other?) "NAME" MEANS THE COLUMN NAME 2) What does the "Description" column contain? "DESCRIPTION MEANS THE...

I am doing data dictionaries for our small dept database. About 40 tables and 1000 variables. I will be doing this on Excel. The columns that I will be using are: Name | Description | Var type | Null?| Label | Constrains as you can see some of those are the output of the Describe command so to...

yeah, but where? and what is the sintax? thanks!

So thanks to your help. I was able to sent the parameter list from "FORM A" and call "form B". now I assume that I am still missing something as I get the error messange that says something like "not such parameter name exist in form B" the idea is this, I want the user to be at a record...

well, I thought about that, but since I have like 35 blocks, I wanted to do it at the form level. :P

thanks lewisp, I have place the pre-insert trigger at the form level. the auditing_inserts block has no records at all, its an empty table so far and nothing is writting in it. The intencion is to be able to track the changes on all the blocks by all the users. So ideally what I was trying to...

No commmit, I assumed that the commit gets processed as the record gets inserted doesnt? more info, the auditing_inserts is a block on my form and also a table on the database. I also have a patient block which does receive the data from the form, this table gets the records inserted.