Just to be more clear:
On the client page:
table clients:
.id_client (PK)
.id_country (FK from table countries)
...
table countries
. id_country (PK)
...
...other tables
On the vendors page:
table vendors
.id_vendor (PK)
.id_country (how to make the relationship?)
I could want to make a...
I am designing a big database (over 200 tables). Having all thoses tables is quite hard to read. I can separate my tables on separate pages successfully but I would like to be able to have on each pages the tables for a particular process (i.e. Clients tables on a page, Vendors tables on...
Found the answer:
On the Name tab of the relationship in the Database Properties Window, be sure to change the inverse phrase from "is of" to "is XXX of" where XXX is the name of the column in the FK table. For example, for FK1 below, I changed the phrase to "is HOME_LOC of" and for FK2, I...
Hi,
I have a little problem making 2FK to the same parent.
Here is an example that is not identical but look like my situation:
- I have a table LOCATION, that contain
(ID_LOC,NAME,CITY,...)
- I have a table INDIVIDUAL (ID_IND,NAME,PHONE,...)
Then I have my table INDIVIDUAL_JOB (ID_IND...
The Page_Render did not work because it is called after SaveViewState Event ! Page_PreRender Event is the last event called before the SaveViewState is called, so this was the right choice for you! ;-)
To refresh your memory, here is the order of the events:
- Page_Init
- LoadViewState
-...
With Visio 2003 Pro, I have created an organization chart and have made a connection to a database so I can put shapes on my diagram and get employees directly from my database. This works fine.
My problem is that I have also a directory containing all the employees pictures (the directory...
Hello,
I want to make a little meetings rooms reservations application. I wonder what is the best way to design the database for the case someone wants to book a room for several days or weeks (i.e. 09:00-11:00).
I guess "copying" the reservation multiple times is not the right thing to do...
We are looking to a solution to archive word and powerpoint documents.
We have lessons plans (over 1000) that change regularly and we need to consult previous plans often.
There is a function in Word in the File menu that enable to manage versions but because many peoples can work on the...
Ok i found out that putting a z-index higher than all my others DIV works... I don't know if there is another way althought... It is OK for my case but in some case where everything is dynamic (i.e. the number of divs) it can be hard to determine the "High" value...
Hi
I have a calendar with div layers for each days of a month. Because the layers are not so big (the container layer is 800*600) when events can't enter in the day-layer I display the 18 first characters and I want the user to mouseOver the day-layer and I open another layer containing all the...
verity is hard and complex.. you can just set all your string to lower or higher...
i.e
and LOWER(tblItems.BusinessDescription) Like'%#Lcase(FORM.BusinessDescription)#%'
Have you found an answer to your question? I am trying to find help me too on VSpider but there isn't a lot of ressources...
The forum is now at:
http://webforums.macromedia.com/coldfusion/
You can also go at the community ressources:
http://www.macromedia.com/devnet/community/coldfusion.html
Like you said it depend on what you want to do. You made me think of another feature to add to this script: being able to browse the list with the arrow key. Here is the code (in the findvalue function)
[code]
// if the right or up arrow has been select then goto the next record
else if...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.